Transform Map not updating existing Project Task records

[Community Alums]

Hello All,

I have created transform map to update existing Project Task records. A few things I did:

1. Field Map: Didn't work. Always create new Project Task records never update the existing records. Given below script

 if(action == 'insert'){
         ignore = true;
 } 

Its stop creating the new record but didn't update the existing records.

2. Transform script: Didn't work 

        if(target.wbs == source.u_wbs){
            target.assigned_to = source.u_assigned_to;
            target.u_percent_complete = source.u_actual_work_percent_complete;
            target.u_actual_percent_complete_apc = source.u_actual_work_percent_complete;
            target.work_effort = source.u_actual_effort;
            target.u_critical_activity = source.u_critical_activity;    
        }    

It always creates a new records which I don't want. I know when I give below script in OnBefore or in above script it didn't create the record but it will not update the existing record also.

 if(action == 'insert'){
         ignore = true;
 } 

So help me gurus.

Thanks,

MK

[Community Alums]

Attached field map picture.

[Community Alums]

Here's the script option which I have written. Attached image. Trying to do with a multiple combinations.

[Aman Kumar S]

@MKapoor 

Keep one, either field map or script, i think best way to keep would be field maps and add your script for ignoring if action is insert in transform map script

[Community Alums]

Tried that option too.

Another question: Like in a query we give contains how we can give that at the Field Map level?

[Aman Kumar S]

Why do you have all the choice action as create, it shouldn't be true for all.

Also, in you have two fields as coalesce, WBS and Project field, refer to your source and check if that unique combination is present, unless both value matches for your data in you SN table, it will keep creating new records