Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Directory - filtering for file name - dynamic Input

hamzam
8 - Asteroid

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.

 

 

4 REPLIES 4
markcurry
12 - Quasar

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/62...

 

Hope that helps

hamzam
8 - Asteroid

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)?

 

 

hamzam
8 - Asteroid

@markcurry ,

 

nevermind -- thank you! it is working now I believe

markcurry
12 - Quasar

OK nice one, glad it helped.

Labels