If you uncheck the "Update Existing" setting on the Create/update vendor node, it will only add new vendors but will throw an error on all of the existing vendors. If that isn't an issue, then this will work.
If you do not want the map to have any errors (which would cause any Map Succeeds scripts to not run), put a script in the Restrictions on the Create/update Vendor node that checks the PM00200 table in the database for the vendor and returns true if the vendor does not exist and false if it does. If you need an example of that script, let me know.
Could you please give an example of this script. Thanks Ranga
You would need to write it using a .net script within the restriction in the vendor node. As Dave said you would want to check the vendor master table and if a result is found you would Return False to keep the node from running since the vendor is already there.
We have sample scripts on our knowledge base if you search for "sample scripts" that show how to write sql queries through scripting. Otherwise you can always contact our services team through firstname.lastname@example.org and we can work with you to create the specific script you need.
If you would like to submit an answer or comment, please sign in to the eOne portal.