hi All,

i have a question,how to set check repeat item code in Exchange scheme(import)?

can you help me?

thanks!

Well the one way I can think of to do this is to create a condition script that would take the input item, check a log table to see if it was loaded, if not in the table add it to the load table, if in the load table then skip the record. Now that I read this I am not even sure this will work, but something for you to look into.

Mark has a good suggestion. You can check to see if the item is already loaded in the execute condition, and then return false if you do not want to add the item. This has the same affect as not allowing overwrite in the exchange scheme.

If you need some of the data, you can set a global variable to be used in field condition scripts, and maybe filling in missing values. Or update a table recording differences in values. For instance, if you were loading stock quantity. If you had duplicate items with different quantities, you may want to write to a seperate log report or file what the different values were.