This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?