Dynamic input tool

I am trying to return the first 3 files from a folder based on descending order. I am having trouble bringing them in through the dynamic input tool. Right now I have the dynamic input tool reading the FullPath but unsure how to select an entire folder as the data source template rather than a specific sheet?

alteryx q.png

Developer Tools

Accepted answers

apathetichell

Don't use Dynamic Input -> use a batch macro.... (or a series of batch macros). Dynamic Input has fairly specific limits.

All comments

apathetichell

Don't use Dynamic Input -> use a batch macro.... (or a series of batch macros). Dynamic Input has fairly specific limits.

Pilsner

Hello,

The dynamic input would work if all your tables have the same schema however a batch macro with a standard data input inside could be a better approach as it will handle tables with different schemas without erroring. Using a control parameter you can then overwrite the input file path.

You will notice I also have a filter tool at the start of the workflow. This is simply to filter out the yxdb and yxmc files as I have them saved in the same folder.

Screenshot 2025-01-02 161024.png

Please find attached a folder with 4 excel documents I used as dummy data, a macro and a workflow.

Hope this helps with your problem, please let me know how you get on.

Regards - Pilsner

Dynamic input tool.zip

bmccarthy5

Thanks for the help, I was able to build it out! So, using the macro, these files should update when new files are added to the folder, correct?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703