Dynamic Input to pick up file created every Monday of the week.

[amerchant]

How do you set up a formula to have the dynamic input to pick up the Monday file from the current week?

[IraWatt · Accepted solution]

Hey @amerchant,

Have you tried this:

A directory tool can scan a folder. You can then convert time created to day and then filter on Monday. Sort the files by created time to the most recent. Sample the top row then use a dynamic input to take the most recent file. 

For setting up the dynamic input check Dynamic Input Tool | Alteryx Help

Any questions or issues please ask :)
HTH!
Ira

[amerchant]

Thank you @IraWatt. what should be my input template? Can it be another file in the same folder where I would like the dynamic input to pick up the file from?

[IraWatt]

No worries @amerchant, the template should be an example file, doesn't matter where it is. it tells the dynamic input what column range to look at. Ideally use a file with the same structure as your Monday file.

[amerchant]

Hi Ira, 

I am getting error when I select the input file: There are 2 tabs in file. I used a slightly different flow which should pick up the lastest file created in the folder.

[IraWatt]

Hey @amerchant,

It does really matter what file you use as the template so try just using an example file on your desktop or C drive. It may be that you dont have access to view this file or its open somewhere else.