Input Excel Spearsheet with variable tab name

[EveM]

Hello everyone,

I have an Excel Spreadsheet input that has a variable tab name.

For example: the tab name is "Orange_1234" for now, but in a month, it will be "Orange_5678". The "Orange" part is there to stay but the rest changes everytime I get a new spreadsheet.

Is there a way to tell the input tool to choose the first tab according to the first word its name contains? Or to simply make it choose the first sheet without specifying a name? Preferably without using the dynamic input tool.

Thanks in advance!

Eve

[laceyaidan]

Thanks, Abilash! This is my first Alteryx reply.

I do have Output File Name = "Full Path". I've attached a picture of my workflow. [FileName] doesn't end up in the output at the end of the flow.

[ydmuley]

The "Full Path" should be configured in the Dynamic Input settings as well.

Once you update the settings as per below, in your output you will get a a new column at the last with the file name which will have sheet name at the end of it. You can later parse that column to get only the sheet name.

[laceyaidan]

It's working! Excellent. Thank you!

[terry10]

You can parse the sheet name from the Full Path with the regular expression ".*\|\|\|.(.*)\$."