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

[____39]

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

[Chetan Mahajan]

Hi,

             are you importing data from an Excel Sheet ? or can you please describe your requirement in more details ?

[____39]

yes,I want to update InsysId for target's each record in the Transform script ON COMPLETE

[Chetan Mahajan]

So why you are using Script Automatically it will get add through transform map just make Sys Id field as coalesce so for every new sys_id it will create new record.

1. go to system import sets-->load data module
2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
3. then click on create transform link
4. give it a name,select destination table(table in which u want to upload data)
5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
6. set colesce true to any one field from related list. it will be your unique field
7. click transform

Let me know if u face any problems.

[____39]

I use the below code,but it didn't work? Is it wrong?

for(var i in target){
i.u_insysid = 1;
}