Dynamic Input Error "Does not match sheet or named range in..."

Hello! I'm brand new to Alteryx but I can't seem to find any answers that work to the problem I am encountering.

I have a directory tool that then flows into a Dynamic Input tool. All Excel files in the directory have the same schema and I need everything on a specific tab of each Excel file to append. I provided the sample file to the Dynamic Input tool, chose the tab that I need, and chose FullPath as the Field. However, whenever I run it, it says "[file path + file name] does not match a sheet or named range in [file path + file name] or the Excel file is corrupt"

I know that it's not a file corruption issue as I run into the same problem when I use brand new "dummy" files. One thing to note is that the first part of the error message (indicating the filepath) replaces all backslashes with underscores (see attached screenshot)... not sure if this is significant or not.

Does anybody know what I could be doing wrong?

Thanks in advance!

Brandon

Dynamic Input Error.PNG

Developer Tools

Error Message

Accepted answers

JagdeeshN

Hi @bkreutz ,

One way of easily resolving this error is by appending the sheetname('|||SheetName') to the FullPath returned by the directory tool.

Please find attached a sample workflow.

Do let me know if this helps.

Best,

Jagdeesh Narayanan

sample.yxzp

randreag

hi @bkreutz

Change the action in the Dynamic input , select "change the entire file path"

All comments

JagdeeshN

Hi @bkreutz ,

One way of easily resolving this error is by appending the sheetname('|||SheetName') to the FullPath returned by the directory tool.

Please find attached a sample workflow.

Do let me know if this helps.

Best,

Jagdeesh Narayanan

sample.yxzp

randreag

hi @bkreutz

Change the action in the Dynamic input , select "change the entire file path"

echuong1

The underscores being added/replacing the original syntax is causing the issue, because it's now looking for that path, which doesn't exist.

Can you try adding a formula tool before the dynamic input and having it create the full path field? Make sure to add all necessary parts, including the sheet name. Example attached so you can see my configuration.

New Workflow1.yxmd

bkreutz

Thanks a lot! This worked in conjunction with the other comments as well!

bkreutz

Thank you! This was helpful and worked in conjunction with the previous solution.

Narayanaswamy

If add this error message comes as different schema than the first file

Molson

I have the same error and have updated so that the FullPath includes the sheet name however I am now getting the error that the new sheet name does not match a sheet or named ranged in the file.

Sheet does not match a sheet .png

JPSeagull

Thank you.... such a simple response after a few hours of researching and testing - works perfect!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703