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:
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?