Iterative Process

Question

I have a sample workflow (screenshot below) Where I was reading 2 input excels and doing some data manipulation and creating one excel output file. Now I need to do it in Iterative process where one of my input excel will be iterative. Like in one folder I will be having all my input excel sheets and I need to read all that excel files. Also, Output should be the combined output once Iterative process was finished.

DylanDowrick · Answer

I apologize, you will need the output (with append file) as well:

DylanDowrick · Answer

I would go with this then:

Where the Batch Macro is doing all of the work (cleansing, joining, outputting) and the workflow feeds it the files you need inputted.

cetricelaens · Answer

As per your suggestion here it will union all input data. For me I need to process one excel data at time because from excel I need to split up first 4 rows separately and rest of the rows separately.