Reading in .xlsb, from directory using dynamic input: No Table Chosen

[wonka1234]

Hi,

I am trying to read in .xlsb but getting error No Table Chosen, please select a table from data source.

When inputting in a regular input tool , I get the data fine.

But dynamic input is asking me to choose table.. But i do select the sheet("table or Query") as part of the input data source template input.

any help would be appreciated.

[ChrisWaspe]

Hi @wonka1234 . You may need to use a formula tool to add the sheet (Table) name into the query of the full path eg [FullPath] + '|||Sheet1$'. Please see the workflow attached

[NikiJF]

Thanks very much for this solution which has solved my problem!