Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Duplicating one workflow for multiple sheets of the same format (Help!)

mmishal001
8 - Asteroid

I've created a workflow which cleans data on one sheet and organises it. Essentially, its summarises 240 lines from one sheet into 12 lines of output.

 

I've 80 sheets like on one excel file. They are all of the same format.

 

How do I duplicate this workflow for all the sheets without copy pasting this workflow 80 times. The output - with 80 sheets, I'm looking to get a summary table of 960 lines of output.

 

I presume this has something to do with recording a macro but couldn't find out how it works.

 

Would be grateful if someone the most efficient way of doing this. I've attached the workflow and example file for your reference.

10 REPLIES 10
mmishal001
8 - Asteroid

Thanks a ton @TonyA @BrandonB !!

 

You are life savers!

Labels