No sheet Specified, You must Specify a Sheet- Error

[Pritimishra]

Hi All,

Iam trying to read an excel sheet in dynamic input tool however getting the error "No sheet Specified, You must Specify a Sheet". I have tried below solution but it wont work

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-not-selecting-specific-e...

Please assist on this.

Thank You :)

[MarqueeCrew]

@Pritimishra ,

Here's a "Change Entire File Path" example:

A:\MyExcelDocuments\2022-05-02DailyWorkbook.xlsx|||Sheet1

That's what the dynamic input is expecting.

cheers,

Mark

[Pritimishra]

Thank you for the response but its not working. I have tried here:

Could you please assist me more where i have to put above mention month

[grazitti_sapna]

@Pritimishra , I am not sure what is not working, but the only issue I can see is you are filtering out the file which contains Invoice in its name but the file you have added is test.xlsx. I have re run your workflow and it was working fine for me below is the screenshot and also attaching the workflow which I ran. Please try and if it runs successfully do accept my solution, 

Thanks!!

[Ivafr569]

This produces an issue when inputting into Alteryx as you can only input one sheet at a time using the regular input tool. My Lincoln Financial Portal