Duplicating one workflow for multiple sheets of the same format then to be merged

Hi everyone,

I have multiple sheets with the same construction in an excel file, but they are too many to input them one by one.

I need to manipulate them each separately with a workflow and then merge the manipulated version of each sheet.

I tried with the list of sheets and then the dynamic input but it stacks the sheets, while I need them independently manipulated and only then stacked.

Can anybody help me?

Thanks!

Accepted answers

BrandonB

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

This is a helpful post that goes over different ways to pull data into a workflow. There are ways to use macros to do multiple sheets at one time, but this only applies when the manipulation for those specific sheets is the same.

BrandonB

Using an input data tool you can pull in “List of Sheet Names” which can pull the sheet name for every sheet in a file. This can then be turned into a macro which reads in each one of these sheets for an entire directory.

Someone has built a macro that accomplishes this which I will track down for you

All comments

BrandonB

It sounds like you will want to bring in each sheet as its own Input Data tool and then stack them together by connecting each to a Union tool afterwards given the need to manipulate each file prior to stacking.

BrandonB

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

ffraizzoli

Hi Brandon,

Yes this is the concept, but I have many sheets (about 80) and whose name can vary, so I don't really want to enter them one by one.

However, I have never made a macro so I was wondering if there was any easier solution, which was still more efficient than having 80 input tools.

Thank you.

Fulvia

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703