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?
@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.
User | Count |
---|---|
52 | |
27 | |
26 | |
24 | |
21 |