Insert new or Replace existing Records (based on PK)

[agalban]

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. 

[atcodedog05]

Hi @agalban 

Give update option in output tool a try. It adds new rows and overwrites existing rows based on PK.