Dynamic Input for excel tab names

[hillygreen]

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.

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.

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

Thanks in advance.

[OTrieger · Accepted solution]

@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]

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.