Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Multiple Excel Sheets How to Choose specific sheets

jeh
7 - Meteor
‎10-16-2019 09:03 AM

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?

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
carlosteixeira
15 - Aurora
15 - Aurora
‎10-16-2019 09:14 AM

Hi @jeh 

My be this help you...

 

Best Regards

Carlos A Teixeira
Onlyplan_name.yxmd
16 KB
Reply
NicholasM
Alteryx Alumni (Retired)
‎10-16-2019 09:17 AM

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

New Workflow3.yxzp
Reply
jeh
7 - Meteor
‎10-18-2019 06:43 AM

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

Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels