I have a use case where I'm using Alteryx to materialize a table. It is a daily process, and there can be changes made to prior days - up to 2 weeks in arrears.
The 2 changes I need to capture are
Adding new records (this should be relatively easy) and replacing records that already exist on the materialized table but a change was made after the initial load.
Unfortunately there is no timestamp on the changes, but there is a PK on each record.
Hi @agalban
Give update option in output tool a try. It adds new rows and overwrites existing rows based on PK.