Error - “Dynamic input tool” with Directory tool.

[Mahabirpanigrahi]

HI Data Community,

Requesting for suggestion/help on “Dynamic input tool” with Directory tool.

Am currently trying to get data from multiple sheets. And the excel files are stored from multiple folders along with sub folders.

While following the “Dynamic input tool” with Directory tool logic am getting error which says my data file do not present on the files OR file have been corrupted. So request you to please help how to proceed.

Attaching the file and data-flow for you to check and advise.

Thank you advance !

Mahabir

[RolandSchubert]

Hi @Mahabirpanigrahi ,

you are trying to load Excel files, so you have to add the name of the sheet to the Path you hand over to Dynamic Input tool. I've changed your workflow a bit, it should work now.

Best regards

Roland

[Mahabirpanigrahi]

Thank you Ronald for the reply. 

I did run the flow your shared. and still its giving me same error. Attaching the error screenshot for your reference.

Please advise

Mahabir

[RolandSchubert · Accepted solution]

Sorry, seems I've attached your own workflow. Give the one I attach to this post a try.

[Mahabirpanigrahi]

Super thanks