Free Trial

Alteryx Designer Desktop Discussions

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

Monthly updates of output into Excel with existing data

YL_Wong
5 - Atom

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!

1 REPLY 1
Kaustubh17
9 - Comet

@YL_Wong 

 

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

Labels
Top Solution Authors