question with sam

[suresh kaliappa]

Hi all , I want to load custom software products in servicenow through excel via import set. i am loading only publisher and product. Now in the excel sheet if same record was found with publisher and product then

Ex. there are 4 records in excel sheet which has same publisher and product. so only 1 record has to import in a target table and rest of the records has to ignore.  So can someone please suggest the best approach to do this. 

also , if publisher and product has same data in target table then that record should also not to create in target table. 

[Ct111]

before loading data set coalesce to TRUE on the field which you feel is unique (in Transform Map), and then when you start loading the data , it will check that similar data already exist on the table or not, if present it will update else it will inset new data.