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.

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
Kilo Sage

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