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
attached workflow
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.
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 |
HI @atcodedog05
I have attached the requested. Appreciate if you can help
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.