Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Multiple Excel Sheets How to Choose specific sheets

Highlighted
7 - Meteor

I have an excel sheet that has the following sheets:

 

Sales

Sales (2)

Sales (3)

Receipt 

Receipt (2)

Receipt (3)

 

How do I get only the sheets that have the word Sales using dynamic input?

 

Highlighted
Alteryx Certified Partner

Hi @jeh 

My be this help you...

 

Best Regards

Highlighted
Alteryx
Alteryx

Hey @jeh ,

 

I would recommend using the input tool to pull in a complete list of all sheet names. This can be followed by a filter to only pull in only sales sheets, then a dynamic Input. See photo and Workflow Attached for an example. 

 

Hope this helps, 

 

Capture.PNG

Highlighted
7 - Meteor

Sometimes it is the easiest solution that just goes right over my head. Thanks!!

Labels