We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Output Tool Difference Between Append Existing and Update

Cferrer6
8 - Asteroid

Hello, 

 

Can anyone tell me the difference between outputting using append existing versus update

 

and how does Alteryx know if its new for update (insert if new)

 

screen shot attached

2 REPLIES 2
Maskell_Rascal
13 - Pulsar

Hi @Cferrer6 

 

So the Append option does exactly what you think. It just pastes the data on to the bottom of the table regardless of whether that data is duplicate of something already in the existing table. 

 

Update Insert if New uses a primary key or identifier to find and update anything in the table with the output of your workflow but will also add additional rows if they don't exist. 

 

Here is a good resource explaining how to create primary keys: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Create-Database-Table-Primary-Key-i...

 

Cheers!

Phil

Cferrer6
8 - Asteroid

thank you so much!

Labels