community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Adding new columns to a table that already exits in SQL

Asteroid

Hello,

 

I have been calling an API in alteryx and appending new data to a table in SQL each time. However on the 6th call to the API there are two new columns returned which cause the "Append Existing" output option in the Output data tool to error.

 

Is there a way to flag up new columns that don't already exist in the SQL table? and how can I append these new columns (filling null in for the existing rows in the table) to the table?

 

Thanks!

Alteryx Certified Partner

Hello Izbiz,

 

If you change the fourth option (Append field map) in the output data tool to 'Custom', it should work.

 

Best,

Fernando Vizcaino

Labels