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