ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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