Import Data From Excel File to ServiceNow

[@jai002711]

Nice video! thanks for sharing the knowledge

[@ayeshamussarath3506]

If I had already some data in that table how do I avoid duplicate records from source to target any tips please

[@KarthikParthasarathy]

you can use coalesce on a unique field like number field during transform map, it will not create duplicates, if there is a record created it will update. I will be releasing a series for developing an app where i will cover this topic

[@ayeshamussarath3506]

@@KarthikParthasarathy yes it worked

[@geetika7453]

Is there any way where I can pull multiple invoice copies altogether. Just to clarify I have 50 invoices for which I need pdf invoice copies, currently I am doing one by one which is quite time consuming

[@KarthikParthasarathy]

The video is about importing data from excel to servicenow, please clarify where do you have those invoices ? are they attached to some records ? that you want to import ? as far I know attachements are part of attachement table so there should be a way or a script to pull everything