Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

question with sam

suresh kaliappa
Tera Expert

‎07-27-2025 11:26 PM

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. 

0 Helpfuls
  • 361 Views
1 REPLY 1

Ct111
Tera Sage

‎07-27-2025 11:31 PM - edited ‎07-27-2025 11:31 PM

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.

 

0 Helpfuls