Import or fix script with an Excel file .

Nabs
Tera Contributor

Hello everyone,

I have the following requirement that I am unable to implement. I have been provided with an Excel file containing one column with contract sys_ids and another column with a field for hours worked on the contracts. Therefore, each row has a sys_id and a field for hours worked. I need to update my contract table with the sys_ids of the existing contracts, updating the new field with the corresponding values (I have 240 rows). The complexity lies in the fact that I do not have a field to map, only sys_ids.
Cchange.PNG
Thank you in advance for your time. 

1 REPLY 1

Kris Moncada
Tera Guru

Does each sys_id in the excel correspond to the ServiceNow Contract sys_id?