Inquiry

Question

Hi all

Please take a look at this workflow, each container is the same exact process but reads from a different excel workbook input, and then all the inputs are unioned back to one excel workbook as an output, is there anyway that i can automate the reading instead of having all those containers? as i need to do some other processes for the files and i don't want the WF gets real big only for repetitive acts.

Thanks in advance.

danilang · Answer

Hi @AbdullahMansour90

If the inputs have the same schema, you can do it without resorting to a macro.   In your first container, change the input tool to use a wild card path.  Disable all the other containers.   This will read the records from all the files and union the results.

Dan

Luke_C · Answer

This article should help you!

AbdullahMansour90 · Answer

Hi,

Yes they do, can you please advise how to do it through batch macros? i tried but not getting anywhere.