Multiple Excel Sheets - One At a Time

[jking_amig]

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!

[ChrisTX]

Have you seen this Knowledge Base article?  It includes a batch macro.

The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[Felipe_Ribeir0]

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.

[ChrisTX]

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]

Hi @jking_amig 

It worked?