Repeat a workflow created for a tab across the entire excel workbook

[SrinivasanSugumaran]

Hi TEam, Can you pls. help me in getting the output. I need to compute the difference btwn. two input files (rows/cols are same btwn. the inputs). I have created a workflow and its producing the desired output. I need to repeat the same for 17 tabs in a single workbook (the row/cols. are same for the entire workbook). I can copy the created workflow 17 times and produce the desired output, however, is there any other better approach to get the output. Attached the sample workflow

[SrinivasanSugumaran]

attached workflow

[atcodedog05]

Hi @SrinivasanSugumaran 

You can create combination of 2 sheets names as key and pass through batch macro to run for each combination.

Here is a resource on batch macro

Interactive lesson : https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

Video : https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

If you share a sample excel file with multiple sheets we could help you out with a sample workflow on how you can make it work.

[SrinivasanSugumaran]

Thanks     atcodedog05, much for help.

I am unable to attach the spreadsheet for some reason here, though its size is only 20kb.

Pls. find below the inputs (Input1, Input2, Input3, Input4) and i would need the output in a excel workbook with 2 tabs.
Tab 1= Input1- Input2
Tab2= Input 3- Input4

Input1:

A	B	C	D
100	200	300	400
50	60	70	80

Input2:

A	B	C	D
5	10	15	20
1	2	3	4

Input3:

A	B	C	D
500	600	700	800
50	60	70	80

Input4:

A	B	C	D
5	10	15	20
10	11	12	13

[SrinivasanSugumaran]

HI @atcodedog05 
I have attached the requested. Appreciate if you can help

[mceleavey]

Hi @SrinivasanSugumaran ,

Firstly, you don't need to copy the entire thing 17 times.

I've attached a couple of tools and a working example.

The first loads in all sheet names of all files in the folder you're looking at (and sub-folders if required). This is then added to the full path and fed into the second tool which loads them all in and unions them together (you can then split them out and use the data cleansing tool to drop the null columns).

This will allow you to load them all in.

Let me know if this fixes the first problem.

M.