Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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