Issues with Data transformation and Iterator

I am taking data in one Airtable Table and transforming the data and copying it to another table using an Iterator. Specifically taking data formatted as:

Name, A, B, C, D and transforming to:

Name, A
Name, B
Name, C
Name, D

Everything works as expected, except for the Upsert when data changes. The Last modified date used in the trigger for the “Airtable Watch” is per row, so when any data changes, it ends up creating all of the 4 rows (per above) again, even though only one field changed.

Is there a way to ensure only the changed data updates or is created and everything is not written from scratch?


@Jeff_Mottle :raised_hands:

Hi Jeff, thanks for your post. We understand that you are trying to transform data from one Airtable Table to another. We would like to help you with this issue, but we need more information to do so. Could you please provide us with more details about the issue you are facing? We appreciate your patience and look forward to hearing from you soon.

Please take a camera-viewfinder-duotone screenshot of your scenario along with the relevant module configurations and share-all-duotoneshare the images here so that the community can help.

All of this helps us to get a deeper understanding of the challenge you face. :make: