Render data in different folder dynamically

SH_94

Hi community, I trying to explore if we can generate the output dynamically without creating folder manually. I have data list whereby it contain week data and i have to create folder every first week manually folder and change the file directory for each output. May i know if we can adjust it in the alteryx without creating the folder manually , sometime i need to create folder monthly meaning 0625, 0725 and etc, and some data i need to save it weekly - 04082025, 11082025. Thank you.

KGT

The only way that I know how to do this is to use a Run Command tool to make the directory using a BAT file. You could definitely make this a lot better with a designated BAT format, but this is just a quick off the top of my head.

• Get output location as a field
• FileGetDir([Field])
• Construct a BAT with the command md [Field]
• Use Run Command writing out that file and then executing producing a result, or using a dummy file to read back in.
• Append the output to your stream (going around the Run Command) and then drop that field straight after followed by a BUD ---- this is just making sure that the Run Command completes and then the workflow can continue.
• Write using Output Tool and option to take filename from field (Change Entire FilePath).

FileExists(Path) may also help in order to check if the directory is already there somehow.