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.

In the Transform script ON COMPLETE, how to get target's records?

____39
Tera Contributor

I want to update target table's many records, use for or while? how to write script? thank you!

8 REPLIES 8

See ref Vid how to import data : https://www.youtube.com/watch?v=rpOyFv19E4E

do you want to give some unique number for each INSYID for every record at time of insertion ?

Do you want to populate a unique number in INSYSID ? or do you want to populate current sys_id in INSYSID ? 

I want to populate a unique number in INSYSID , if i use target.u_insysid = 1,it only updated a record, I just want to know how to updata all target records in the Transform script ON COMPLETE? thank you!