Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Insert new or Replace existing Records (based on PK)

agalban
5 - Atom

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. 

 

 

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @agalban 

 

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

Labels