Directory - filtering for file name - dynamic Input

Hello,

My use case is the following: every day, a new file will be posted in a directory, from which I would like to extract this file...

it's structure looks like this: 100_the_file_name_33_33.xlsx

100_the_file_name_ is the same each day, but the last 2 numbers change.

I would like the workflow to be as automated as possible; could you please provide guidance on how to

load in this type of file dynamically?

Here is what I have done, but it looks like I have a problem with the dynamic input configuration.

Input

Dynamic Processing

Accepted answers

Hi @hamzam , I did a similar workflow, see this post here...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-specific-file-from-a-folder/m-p/625699

Hope that helps

All comments

Hi @hamzam , I did a similar workflow, see this post here...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-specific-file-from-a-folder/m-p/625699

Hope that helps

Nice!

So, in my case this type of file will be the only one that has the 100_the_file_name... type of name, just with a different number at the end; with your workflow, would I need to know these numbers; I don't have access to them (they are generated elsewhere)?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703