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

Question

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

variance analysis_output one below other.yxmd

mceleavey · Answer

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.

Multi Sheet Import Example.yxmd

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

SrinivasanSugumaran · Answer

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

SrinivasanSugumaran · Answer

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:

ABCD10020030040050607080

Input2:

ABCD51015201234

Input3:

ABCD50060070080050607080

Input4:

ABCD510152010111213