Indicate a Generic Sheet Name in the Formula Tool

Hi Guys,

The sheet name of my excel file differs everyday. The format for example is "Indicatives-20230811-1709". In the sheetname, what changes everyday is the second and third part (which is 20230811 and 1709). Please advise how can I translate it in the formula tool. Below is my syntax in the formula tool but it is getting an error. Is it possible to use * (asterisk) after indicatives?

Looking forward for your assistance.

Thank,

Kamen

Workflow

Common Use Cases

Accepted answers

All comments

AncientPandaman

you change the file input tool. to load by sheetname only. then only use dynamic input or macro to load that sheets.

if the sheets are too many, you can use filter before dynamic input

Screenshot 2023-08-15 125806.png

KamenRider

Hi @PangHC

Do you have a sample screenshot or worfklow where I can see on how to do it?

Thank,

Kamen

AncientPandaman

@KamenRider here you go.

Screenshot 2023-08-15 135908.png

KamenRider

Hi @PangHC

Thanks for the response. However, I am using directory tool in inputs. Is there a way you can give me sample on how to get the sheet name with using this tool?

The structure of my workflow looks like this.

Thanks and looking forward for your advised.

Kamen

AncientPandaman

@KamenRider you can use two dynamic input tools. one for import sheets name, another for read the sheets.

here the workflow. do generate a blank excel with name "a.xlsx" to run without error.

Screenshot 2023-08-16 093018.png

load file.yxmd

KamenRider

Hi @PangHC

I configure the location of the shared drive in the directory and found an error as follows:

List of sheet name.PNG

sheet name.PNG

Please advised.

Kamen

Felipe_Ribeir0

Hi @KamenRider

Unfortunately, if your file is a .xls file this approach will not work properly. xls files are legacy at this point and use old Microsoft drivers.

One way to approach this problem is by converting the files from .xls to .xlsx and then, apply the method shared by @PangHC .

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-to-Read-the-Contents-of-the-File-using-the-Sheet-Name/td-p/1175794

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335