Add a table to the existing list of import set tables

becks_kirk · ‎05-15-2017

I have an excel file that I'd like to load against an existing table in ServiceNow. My issue is that when I attempt to "Load Data" the table isn't listed in the existing tables list. How would I go about getting this table added so I can update the table with 300 records in an excel file?

SanjivMeher · ‎05-15-2017

If you are using Load Data option, It is actually asking you for an import set table.

Import set table will be a staging table, where data will be stored temporarliy. And then you can create a transform map to map that table.

So you should select Create Table option.

Another option is directly go to the main table, where you want to load data. And rigth click on header and select Import, where you can directly load data.

Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

becks_kirk · ‎05-15-2017

I have a column of data that should be the main field that's referenced. If the record exists, I want the rest of the columns to update with the corrected data. If it's new, I want a new record inserted.

SanjivMeher · ‎05-15-2017

Hi Becky,

Please mark the thread answered, if it answered you question.

Also, did you use import set?

It is recommened to use import set, if you want to load data, which may already exists.

You can set a field coalesce, which is unique. Based on this field, data will be either inserted or updated.

Coalesce options

Please mark this response as correct or helpful if it assisted you with your question.

SanjivMeher · ‎05-15-2017

Below is an example. We are syncing the AD user data with Servicenow data. user_name is the coalesce, since it is an unique attribute for every record.

Please mark this response as correct or helpful if it assisted you with your question.

harika26 · ‎10-31-2021

hello,

can you please let me know what script you have used for updating the new records from main table to staging table.