Multiple Excel Sheets - One At a Time

Question

Hello Everyone -

I am hoping the community can help me get a project I'm working on to the finish line.  I have a completed workflow built that works as I need it to for one sheet of data.  Now I'd like to modify it to handle multiple excel sheets in the same file, with the same schema, but run them one at a time and union the results at the end.

Sheet1 - Import, run workflow

Sheet2 - Import, run workflow

etc.

Union Results

I have attempted creating a batch macro to do this but haven't had much luck.  Any assistance here or examples where this has been achieved would be greatly appreciated.

Thank you!

Felipe_Ribeir0 · Answer

Hi @jking_amig

It worked?

ChrisTX · Answer

Or, when calling the macro provided by @Felipe_Ribeir0 , use the Group By tab, and you may not need to use a Filter tool inside the macro.

Chris

Felipe_Ribeir0 · Answer

Hi @jking_amig

Yes, to do this you need a batch macro. See the attached example.

The idea is

1)I am giving to the macro the entire dataset (ColumnA, FileName)

2)I am giving to the macro one parameter (FileName) to filter the dataset and do whatever is being done inside the macro

The secret here is to properly configure the filter and the update value tool

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

wf_example.yxzp