Dynamic Input not selecting specific excel sheet

I have searched many topics and I haven't found a tip to solve this yet! Though I am sure I am not the first person to have the issue.

I am setting up my workflow for a specific report to take in the most recent file from a shared drive. My issue is in selecting the correct SHEET once the file is found. I am using the Dynamic Input took to bring in my data, in the settings I am choosing the sheet I want to take data from, however I continue to get an error that I need to specify the sheet.

See screenshot! I have tried a few solutions, none of which worked. Anyone know what I'm missing?

Sam

2021-05-21_14-17-02.png

Input

Error Message

Dynamic Processing

Accepted answers

SamStig

Neither of these ended up being my solution - though they may BE a solution, what worked best for me was using a Filter tool to choose the sheet name before the Dynamic output....

2021-06-02_13-19-46.png

All comments

AkimasaKajitani

Hi @SamStig,

Does the input file contain unnecessary sheets?

I succeeded in showing the same error.

When I add the unnecessary sheet to the input file, the error occurs.

Please check the input file.

mceleavey

Hi @SamStig ,

I've attached an example and the two tools you need.

Simply add a sort tool after the directory and sort by creation time descending, then a sample tool to pick the first one. This is the latest file.

Then my tools do the rest. They find the sheet names and then dynamically load them in.

You can filter down to the sheets if required.

I hope this helps,

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Multi Sheet Import Example.yxmd

SamStig

This makes sense! I know there is one hidden sheet in the file and could likely be the culprit. I will report back if this solves.

SamStig

Thank you @mceleavey! As an Alteryx beginner, can you share with me how to install the custom tools you made? I believe this may be the solution, as removing or unhiding hidden sheets didn't solve the issue. thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703