how to update multiple records in target table from one record in source table in a transform map?

[ashwanikumar]

Hi All,

i have multiple records in a target table with the same user ID. As per the requirement i want to update all the records in target table using one source record.

i am using an excel with data for 5 fields. rest of the column data will remain same.

how can i achieve this?

Thanks,

KUMAR

[Ankan Mukherjee]

Hello,

Any update on this?

Is the above code is working for anyone?

[Chandan1]

Hello,

I am using this code and working fine. You can use it in field map by checking the checkbox "Use source script". Please see the attached screen.

[Chandan1]

This will update once source filed to multiple target field records based on the condition.