Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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 Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Wild Card Sheet Names

Status: Accepting Votes Submitted by on ‎08-18-2020 05:50 AM
7 Comments (7 New)

Would be amazing if we can use a wildcard to input data from multiple sheets within an Excel workbook. 

 

This would be particularly useful when dealing with older Excel spreadsheets such as .XLS and .binary spreadsheets such as .XLSB.

 

 

See more ideas labeled with:
7 Comments
josephschafer
Alteryx Alumni (Retired)
‎08-18-2020 07:03 AM

There's already a way to do this but it does require two tool: Input and Dynamic Input.  It's not too complicated though.

 

josephschafer_0-1597759327159.png

 

0 Likes
jacob_kahn
12 - Quasar
‎08-18-2020 07:05 AM

Hey @josephschafer 

 

Thank you for sharing this with me.

It doesn't solve my issue while using legacy documents such as .XLS and .XLSB...

0 Likes
josephschafer
Alteryx Alumni (Retired)
‎08-18-2020 07:39 AM

Ah.  Yep.. I see what you mean.  

0 Likes
KylieF
Alteryx Community Team
Alteryx Community Team
‎08-20-2020 02:14 PM

Thank you for your feedback and idea!

 

 I've conducted a quick review of this idea to insure it has all the necessary components present for when the criteria is met for the idea to be submitted to product, and it looks good. Be sure to check out the other product idea boards as well as like any other ideas that would benefit you!

DMURPHY
6 - Meteoroid
‎12-04-2020 08:21 AM

Another vote for this idea.  

0 Likes
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
‎08-31-2022 05:22 PM
Status changed to: Accepting Votes
 
0 Likes
Newt
8 - Asteroid
‎01-10-2023 04:08 PM

What I seek is a way to accept changing sheet names.

Say you download an Excel file each week with the same name, but the sheet name changes with that day's date, such as "Data 23-01-01"  then "Data 23-01-08" and so on.

If I could have the Input tool accept sheet names with a wild card, like "Data*" then I would be very happy,

Labels