Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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