I have made two fields as coalesce but still it is inserting new record for same combination

Pradeep Patel1
Tera Contributor

‎06-27-2024 11:32 AM

Hi All,

 

Here my requirement is If In the target table there is entity with same RAM means entity is XX and RAM is YY and other records comes with same entity and RAM I want to just update the other fields and record. so I made those two fields as coalesce true but is still not working, please help me in this.

PradeepPatel1_0-1719513097447.png

 

0 Helpfuls
  • 438 Views
2 REPLIES 2

Pratiksha
Mega Sage
Mega Sage

‎06-27-2024 11:36 AM

share the sample record which you want to update or insert. Also share where you are trying to insert the record. 

0 Helpfuls

Pradeep Patel1
Tera Contributor
In response to Pratiksha

‎06-27-2024 12:00 PM - edited ‎06-27-2024 12:03 PM

Hi @Pratiksha  ,

following record I am trying to update and others to insert

PradeepPatel1_0-1719514709760.png

PradeepPatel1_1-1719514815905.pngPradeepPatel1_2-1719514841445.png

PradeepPatel1_3-1719514933509.png

 

Functional area is nothing but the class of the entity, label name shows the whatever the class entity has, backend name is entity only

 

0 Helpfuls