Error - “Dynamic input tool” with Directory tool.

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

Test.zip

Datasets

Dynamic Processing

Accepted answers

RolandSchubert

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

Test.yxmd

All comments

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

Test.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703