Dynamic Input tool - Must specify file name

RasmusTS

Hi everyone

I've adapted edited a dynamic input tool, which will import an excel file from a specified folder, while dynamically changing the path to match the Username of the one running the workflow. 

However, I would like to be able to input any excel file in the specified folder, rather than only the one specific file. 

In the normal input tool i would be able to change the file path to say "/*.xlsx", but I find that this doesn't work with the dynamic input tool. 

Is there an "easy" way to fix this?

Thank you in advance. 

Connecting input dynamically.yxmd

DataNath

@RasmusTS what error are you receiving when trying this? Wildcard inputs should still work with the Dynamic input tool:

However, this will only work if you have Excel files that follow the same schema i.e. the names, order, data type etc of every field.

If you have files with varying schemas then you'll need to go down the route of a batch macro - there's a great article here outlining all the possible routes of inputting multiple files: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480