We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Input for excel tab names

hillygreen
5 - Atom

Hi all,

I am currently working on inputting excel sheet with dynamic tab name.

For example, I have a excel file named "dynamic_sheet_name0125.xlsx". I make it a dynamic input by adding a wild card in the "0125" part as the following workflow.

Screenshot 2025-02-07 001301.png

 

Screenshot 2025-02-06 234843.png

I would like to get the tab name with [current year]+0701, which is 20240701. And [current year] is a variable that changes every year so the excel tab name is also dynamic.

The problem is Alteryx does not support dynamic sheet name as the sheet name is fixed in dynamic input tools.

Screenshot 2025-02-06 235511.png

What should I do to for inputting dynamic excel tab name in this case?

Thanks in advance.

2 REPLIES 2
OTrieger
13 - Pulsar

@hillygreen 
You can leave the * before the .xlsx. Now instead calling for a specific sheet name you can ask <List of Sheet Names> by doing it Alteryx is list the all the sheet names in this file, then with a formula tool you can replace the <List of Sheet Names> with [File Name], that will create for you the full path for each of the tabs. With a filter tool you can filter on year or whatever is needed to get the desired sheet name

SPetrie
13 - Pulsar

Make sure you are also replacing the entire file path in the dynamic input

 

I believe I just responded to this same question on Reddit. I dont see any real reason why your current method woudlnt work other than the setting I mentioned.

Im attaching a workflow that does the same thing. It also contains a version using the method @OTrieger suggested which is to pull a list of sheet names and filter to the one you need.

input.PNGoutput.PNG

Labels
Top Solution Authors