How to append daily data in excel output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Respectable All,
i have created a Alteryx workflow, which i will run daily and it will give daily basis data, i want the output in one excel in one single sheet but today's data should be paste below the yesterday's data, kindly help with the logic, i tried using append to existing sheet in output tool but its showing error (Error: Output Data (100): Incoming field named "DATE " cannot be appended. All incoming fields must match (or be mapped to) a destination field name.)
there is no specific range since the daily data is fluctuating.
Thank you :)
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Anbumani
one work around is
you can read the file and then union the new data and rewrite to the sheet
this will be easy and effective.
mark done if solved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi agree with the solution however if i read the output file again and perform union, if the data is huge this will slowdown the workflow, please suggest any other possible solution.
Thank you so much
