Dynamic Input tool

[Vishnusai]

Hi All,

While i am using Dynamic input tool i am getting the below. can any suggest

[Luke_C]

You need to tell it what sheet of the xlsx file to load. If all the files in your directory have the same sheet name, you can append the filepath with '|||TabName' will work. If they're all different, check out this post to use a macro to read in the tab names.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-worksheet-names-from-excel/td-p/34...

[atcodedog05]

Hi @Vishnusai 

You would need to the sheetname like using a formula tool like below. Here my sheetname is Sheet1.

Hope this helps : )

[Vishnusai]

Still i am getting the below error

Dynamic Input (5) C__Users_X019256_Desktop_Alteryx_vishnu_09081988.xlsx___sheet1 does not match a sheet or named range in C:\Users\X019256\Des

ktop\Alteryx\vishnu_09081988.xlsx or the Excel file is corrupt.

[Luke_C]

Hi @Vishnusai  You need to use pipes instead of underscores. 

[binuacs]

@Vishnusai seems to be you are using back slash (\\\)instead of pipe (|||) before the sheet name. please follow as @atcodedog05  suggested

[atcodedog05]

Hi @Vishnusai 

can you share your dynamic input tool config.

Happy to help : )

[Vishnusai]

[MichelleL]

@Vishnusai I believe you need to change the 'Action' to 'Change Entire File Path'.  I've attached a workflow with several examples of how to pull in Excel files dynamically, depending on your situation.  Your sample matches closest to the 1st container.

Let me know if this works for you!

[Vishnusai]

@MichelleL iam using the older version of alteryx, I am unable to export the marco in my machine. can you send the screenshot of the Configuration