Import Excel Sheet where name slightly changes

[LoganDougherty]

Hi All,

I'm trying to configure my input tool to use a wildcard in the Sheet name. The file name will be static but the Sheet Name with be some variation of "Export-*" (Export-1,Export-2,Export-3,etc.). I can't seem to find how to do this in the normal Input Data tool.

[gautiergodard]

Hey @LoganDougherty

You could try something a bit more dynamic, like this: 

[Luke_C]

Hi @LoganDougherty 

The following thread should help, typically the dynamic input or batch macro approaches work best here. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-dynamic-sheet-name/td-p/746247

[LoganDougherty]

I dont think my firm has the newest version of alteryx available because I cant download your solution. Would you mind showing me how you have the dynamic input configured?

[gautiergodard · Accepted solution]

@LoganDougherty Try this.

You just have to import the packages.

Basically you'll want to use the input tool to bring in the sheet names of your workbook, using those sheet names and a formula construct a full path, and then pass that path into the dynamic input tool.