We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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!