Iterative Process

[cetricelaens]

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.

[T_Willins]

HI @cetricelaens,

Since you are looking for a single combined output, instead of an Iterative Macro, can you bring in all the files at once using a wildcard?  If there are schema errors, that can be solved with a simple batch macro.  

[DylanDowrick]

Without specific information I am providing a rough guideline using a batch macro:

The directory would be pointed at your input files that need to be pulled in and the batch macro unions them together if you can't use a wildcard input.

[DylanDowrick]

If you really do need each file joined individually, you could stuff the file join within the batch macro (along with the file export--make it append) and then run the macro off of the directory with a browse following it.

[cetricelaens]

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.

[DylanDowrick]

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.

[DylanDowrick]

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