Monthly updates of output into Excel with existing data
- 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
Hi All,
I have an input Excel file with one sheet of data that I've used Alteryx to split into an output Excel file with multiple tabs based on a field ("Tab").
Each month, I get a refreshed input Excel file with that month's data.
How can I get the next month's file to copy over to the existing output Excel file?
e.g.. I receive Jan data in one sheet, use Alteryx to split into multiple tabs in "Output file".
When I receive Feb data in one sheet, how do I program Alteryx to split into multiple tabs but paste below Jan info in the "Output file"?
Thanks in advance!
- Labels:
- Input
- Output
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, according to me you have set the setting to append the data in the output tool. So whenever you get the monthly file just add to the flow and keep setting as append. If it possible you can share the dummy data with desired result.
Best,
Kaustubh
