Create Folders and Subfolder

Question

Hi,

I want to create a folder when I enter name in the input box. Like If I enter AK1. AK1 folder should generate.

When I create AK1, subfolders TeradataExtracts and workspace should be generated, like-

And in workspace, folders should be generated for current datetime like this-

And in datetime folders for we have to write data example.xlsx. All steps are like mkdir.

Thanks

Example.xlsx

mbarone · Answer

Hi @amitanthem145 .  The way to do this with Alteryx is to use the Run Command Tool (links to Tool Mastery Index, but here's a link to the help files for the tool as well).  First create your paths using some combination of a formula tool or even a directory tool.  However you want to dynamically create those full paths - up to you.  You would create a .bat file with a mkdir command for each one you want.  And then the Run Command tool will execute that .bat file.

So the .bat file would have have a bunch of lines like this:

mkdir "M:\Avg_SD_Trend_Vars\Data\Archives\2022\2022_01"
mkdir "M:\Model_Outputs\ASODiscountSensitivity\ToBeScored\Scorecard_Data\2022\2022_01"
mkdir "M:\Model_Outputs\ASORetention\ToBeScored\Scorecard_Data\2022\2022_01"

And then the you'd connect that to the Run Command tool and configure it per the links above.  Give it a shot and let us know if you have any trouble.

ChrisTX · Answer

You can create a BAT file and call it through a workflow event, or use the Run Command tool.  Powershell is another option.

Here are a few examples:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Renaming-files-at-system-level/m-p/370717#M68104

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-Run-Command-to-Move-files/td-p/8958

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-File-AUDIT-Issue/td-p/452077

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Run-Command-with-self-delete-element-not-working/td-p/461422

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-new-folder/td-p/54472

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-update-Run-configuration-using-Actions-tool/m-p/392453#M71917

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copy-a-XLSM-Template-using-a-bat-script-to-two-locations-and/m-p/440055#M83498

Chris