Help: Using Run Command tool to create a folder

Hi all,

I have a workflow that gives me 3 excel file outputs at the end. When I run the workflow, I would like for it to automatically create a folder in a shared drive, with the folder named as "today's date" and have my 3 excel files saved in that folder

I heard that a run command tool can be used but I have absolutely no idea about the configurations. Does anyone know how to go about doing it / guiding me with the exact steps?

Also, a side question, is it possible to do this without a run command tool?

Thank you so much!

Help

Run Command

Accepted answers

Qiu

@Eunice_97
Just a quick sample

New Workflow3A.yxmd

All comments

apathetichell

This thread (including the -p addition in the last post) walks you through the mkdir/alteryx interface and provides a batch macro in a workflow to show you how to implement...

I think the all important link didn't post so here it is again:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-create-folders-and-output-excel-file/td-p/524818

Qiu

@Eunice_97
Just a quick sample

New Workflow3A.yxmd

LATHROPS

Just to add something, the -p does not work (or at least for me) in the Windows environment with mkdir or md. Instead I used the following command: "if not exist ." +[DirName] + " mkdir ." + [DirName]

The periods are there because I want the folders created at one level above "_externals".

Now just tweaking the workflow to guarantee the folders are created before the output tries to place files in them.

TheOC

hey,
Just to add - i released a free tool on the Alteryx Gallery for this job:
https://community.alteryx.com/t5/Public-Community-Gallery/Create-Folder-Path/ta-p/928839

This uses the run command similar to as discussed above. Feel free to open the macro and see how it works (I haven't locked/encrypted the macro, so if you just want the logic it may be useful).

The logic is simple, an explained in the source above - i use a command to check if the folder path first exists, and if not, i use the mkdir command.

Hope this helps,
TheOC

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703