Coalesce true not working for updating the record - transform map

Prathamesh Cha1
Tera Contributor

‎08-02-2024 03:02 AM - edited ‎08-02-2024 06:32 AM

earlier it was updating the record when record got match with the entity and current RAM combination but now it is inserting it for the same file even though record matched with entity and Current RAM combination.

 

PrathameshCha1_0-1722592927123.png

PrathameshCha1_1-1722605515609.png

 

 

PrathameshCha1_0-1722605481361.png

 

No other script is written for this

0 Helpfuls
  • 176 Views
2 REPLIES 2

Community Alums
Not applicable

‎08-02-2024 06:19 AM

Hi @Prathamesh Cha1 ,

Please check if you can change the "Choice Action" to " Ignore".

Also, check if there are any before-query business rules on the target table.

 

0 Helpfuls

Prathamesh Cha1
Tera Contributor
In response to Community Alums

‎08-02-2024 06:43 AM

Hi @Community Alums ,

 

tried making choice action ignore but didn't work, also no BR is written on this table

0 Helpfuls