Alteryx Designer Desktop Discussions

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

Add new fields to existing sheet

empettit4
5 - Atom

Hello,

 

Running into errors trying to append data to an existing sheet, is there a way to dynamically add new columns to the below sheet?  I'm trying to track counts and averages over time but there may be new columns and columns may drop off if the team changes. Happy to answer any questions to help get an idea of what I'm trying to do. The column "_Empty was not in the previous runs and ran into errors trying to append. Thanks, Evan

empettit4_0-1668612780321.png

empettit4_1-1668612831890.png

empettit4_2-1668612849877.png

 

 

 

 

1 REPLY 1
JoshuaB
Alteryx
Alteryx

Hey @empettit4 

 

Somebody correct me (@TheOC would know....) but I don't think you can do it that way. I would probably go the route of bringing in the sheet data, append in Alteryx and then write the finished dataset out to Excel (replace the sheet). 

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter
Labels
Top Solution Authors