Dynamic Input No Table Chosen Error

I'm trying to use the Directory input to grab a list of the most recent created date file and then use the dynamic input to grab the correct data. I'm running into the issue where the dynamic input is telling me "No Table Chosen; Please select a Table from the data source".

When I select the dynamic input data source template and select the file, and the refresh my data shows up. But running the workflow is does not work.

TEST Alteryx.xls

Developer Tools

Input

Error Message

Output

Best Practices

Dynamic Processing

Preparation

Accepted answers

@ddiesel This is the solution that worked for me. In the formula tool I put the below. Name Sheet1$ to the sheet name of your file.

[FullPath] + "|Sheet1$"

All comments

If the table name is consistent, You have append excel sheet name to file path.

Example: c:/Project/sample.xlsx|||:`Sheet1$` (Fullpath+"`Sheet1$`

I tried to add the file sheet and am still getting an error.

Thank you all!!! This worked for me:

This worked for me as well.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703