We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Can't find a way to generate multiple excel files using a template

jaypatnaik
6 - Meteoroid

Hello,

 

I have a workflow where I use a combination of a macro and dynamic input to source multiple excel files in a directory, perform some manipulations, generate an output file for each input file (using a dynamically created Output File Path based on the input file path name). I'm looking for a way to generate each one with two "dummy rows" above the data, the first saying classified in cell A1, and the second row being a blank row. The headers in the file have to be in row 3 as shown in the second screenshot. I have tried using a union to append the rows, using a template file and appending, but those options do not seem to work. Is there an easier way to do this?

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@jaypatnaik 
I believe that you have overcome the part of importing multiple Excel files with a batch macro.

Then in order to add 2 rows as you have requested, we can do something as below.

In the Input tool, check the option "First Row Contains Data" which will bring the header in.

0203-jaypatnaik.png0203-jaypatnaik-A.png0203-jaypatnaik-B.png

Labels
Top Solution Authors