How do you set up a formula to have the dynamic input to pick up the Monday file from the current week?
Solved! Go to 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
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?
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.
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.