checking the active and inactive Recodes in custom Table using Transform map script.

Venkata reddy
Tera Contributor

‎07-03-2024 01:20 AM

Hi All,

 

I have a requirement where the data comes from a (third party/Data Hub ) and it updates in a custom table.

we are using transform maps to map the data into custom table.

case1 : I have two records in the custom table with same location ID ( location ID is the unique value) which is refers to cmn_location table. One is active and other was Inactive Records . So if there is any update that was coming through the data then it has to check the active record and update it and it should ignore the inactive record.

case2  : In custom table there is only one record and it was inactive if there is any update receiving then the system should ignore that update.

 

Can you please help me with this.

Thanks in advance

0 Helpfuls
  • 220 Views
1 REPLY 1

Vrushali Kolte
Mega Sage

‎07-07-2024 08:23 PM

Hello @Venkata reddy ,

 

To accomplish this, set the coalesce value of both the location and Active fields to true on the field map. This ensures that only the records with a unique location and an Active status of true will be updated.

 

Additionally, if possible, delete any unnecessary records that are inactive. This will help maintain a clean and accurate dataset.

 

If my answer solves your issue, please mark it as Accepted ✔️and Helpful 👍based on the impact.

 

 

 

 

0 Helpfuls