Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Dynamic Inputs

Highlighted
6 - Meteoroid

Hi everyone,

 

I asked a similar question with regards to dynamic outputs which was extremely helpful.

 

Is there a way make the input a file inside a folder. I'm working with a single Excel file but the name of it will change on a weekly basis (e.g Financial results - WC date). Is there a method if building an input which would function without having to change the file input each week?

 

Any help is appreciated.

 

Thanks

 

Highlighted
Alteryx Partner

What's the rule for the changing filename ? Is it the date component or something else ?

 

It's hard to answer until we know this information or at least a better idea of your situation.

Highlighted
6 - Meteoroid

It would be purely the date function.

 

i.e. Financial results - 15/02/2019. The string 'Financial Results' will never change. The date component will.

Highlighted
15 - Aurora

here's one way.

 

Use the Directory tool to load the list of files in the folder, sort on creation time and sample the latest one only. If you know the SheetName, for instance, Sheet1, then add it to the Fullpath and use the Dynamic input tool to load it.

 

load latest file.png

Highlighted
Alteryx Partner

Just remember that you can't have slashes or backslashes in the filename.

 

Other replies on this thread are also great, but if you want to load an exact filename I'd use something like this (attached)

Labels