How to iterate passing differnt values and union results

Question

I have 4 files in same directory with different subdirectories name and excel file with A1:B13 data.

I am able to create flow as below

Directory -> Filter  Fullpath "A" -> Filter filename xyz -> formula full path MTD$A1:B13 -> dynamic input ->  format -> display in a row

Directory -> Filter  Fullpath "B" -> Filter filename xyz -> formula full path MTD$A1:B13 -> dynamic input ->  format -> display in a row

Directory -> Filter  Fullpath "C" -> Filter filename xyz -> formula full path MTD$A1:B13 -> dynamic input ->  format -> display in a row

With connector union all and export to excel

Is there a way i can pass A,B,C with one workflow (as all the steps are same for each) and append the results to export to excel

gautiergodard · Answer

Hey @radha009

Try the attached workflow with some batch macros i've put together.

The first macro will import all sheets for each file in your directories, and the second macro will import all of the data within those sheets and stack on top of each other based on column header name.

Just replace the folder path in the directory tool with your own.

Hope this helps!

BatchImport.yxzp