Add new fields to existing sheet
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
empettit4
5 - Atom
‎11-16-2022
07:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Tips and Tricks
1 REPLY 1
Alteryx
‎11-16-2022
07:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
