This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to create a dynamic directory tool in order to look if 3 unique files exist within a folder each time I run the workflow. I've read a handful of Dynamic Directory discussion posts and none of them seem to really to solve my issue without an app or macro. I have a tool container that has our company's special accounting calendar that feeds the current period information into a formula tool where I put together the file path I would want to then feed into a "dynamic directory" tool.
The dynamic directory will change from:
Does anyone have any suggestions for trying to achieve this without making a macro or an app? If it must be in a macro or app, can you provide an example of the workflow where you are able to pass this path from a formula tool into a parameter or similar interface tool?
@LordNeilLord Thanks for the starting point, but I'm really grasping at straws for how I could feed values like the year (e.g., 2019 currently, but 2020 in a few months) and the period number (e.g., P11 right now, but P12 in a few weeks) into the directory tool.
Can I connect my formula tool to any of those Control Parameters or Action tools to feed in the fields for year / period into ultimately the directory tool? Otherwise I'm only seeing movement in this macro by manually editing the Directory, File Specification, and include subdirectories fields within the connected Directory Tool. Am I missing something?
Hi @jdunkerley79 - I actually have another question about this... so I see that you're using the /b parameter for dir to call the bare list of directories and files, but I'm trying to figure out the syntax to also call in the creation date timestamp. I tried to use the following syntax: "dir /T:C"
What ends up happening is that Alteryx says there's too many columns, and I think I need to figure out a way to express delimiters or additional columns through the Run Command tool...
I essentially want to be able to reproduce what the Directory tool can do, but utilize the Run Command tool since the location of the directory is dynamically changing every time.