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

Bonnie Bennet
Tera Contributor

‎12-15-2023 11:06 AM

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!!!

0 Helpfuls
  • 958 Views
11 REPLIES 11

AshishKM
Kilo Patron
Kilo Patron

‎12-15-2023 11:21 AM

Hi @Bonnie Bennet ,

You can write onBefore()  script and ignore the record update.

AshishKMishra_0-1702668050112.png

 

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls

Bonnie Bennet
Tera Contributor
In response to AshishKM

‎12-19-2023 06:59 AM

Hi Ashish, 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!!

0 Helpfuls