How to update only an active record through the transform map/import set

[Bonnie Bennet]

Hi All,

I have created a transform map for the service_offering table. I set the Service offering name and company as the Coalesce fields. When there are multiple matches for any row on the target table I want the system to always update the Active record. Can someone please help me know is there a way to do this ? If yes how??

Thanks in Advance!!!

[Saurabh Gupta]

Hi,
You can use a trick here.
Also add "active" in Coalesce.

In the transform script, you can check if target.active == false, then ignore=true.

[Bonnie Bennet]

Hi Saurabh, Thanks for looking into this!

The suggested code line just prevents the update to the target record when it is inactive. But when the target record is inactive, how to move on to next target record to search for an active record and update it ?? 
Thank you!!

[Saurabh Gupta]

Hi @Bonnie Bennet 
Do you have multiple active records as well?

[AshishKM]

Transform map will auto move on next record and again check the same active status, if match found then ignore else update as per field mapping.