We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch Input Macro on Selected Sheets within Workbook

mabook617
5 - Atom

I have created a workflow that I would like to run across multiple sheets with the same schema within my workbook. Note that my workbook contains other sheets that I do NOT want the alertyx workflow to run. Further, the sheets that I will need within the workbook will vary from time to time. Is there a way to create a batch input workflow so that I can select only the sheets that I want from my workbook prior to running?

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

Hey @mabook617,

I think what you want is an Analytical App like this:

IraWatt_0-1656526948252.png

The input tool just gets sheet names then you select which sheets you want. The final macro imports the selected ones (could use a dynamic input there). I have attached both the app and the macro. 

Any questions or issues please ask :)
HTH!
Ira

 

Labels
Top Solution Authors