Hi, I have very huge data which I want to segregate and save in multiple files. Same Data: CountryCityPersonAgeIncomeIndiaDelhiRam281000IndiaDelhiSita27900IndiaDelhiMohan29980IndiaMumbaiMohit30950IndiaMumbaiMisha70AustraliaSydneyMark20200AustraliaSydneyJohn18150AustraliaPerthMicheal455000AustraliaPerthEric382500AustraliaPerthColette15350AustraliaMelbourneIsable21600USNew YorkMark26750USWashingtonJack29800USWashingtonMike24500USSeattleSimon363500USSeattleJack414700USChicagoKelvin27550USChicagoImran331100USChicagoAndy55650 First I want to create folder with "Country" name. Each "Country" folder should have sub-folder with "City" names. Then each sub-folder should have Files with "Person" name. Like below- Kindly help me in creating a workflow for this. Regards, Mohit @patrick_digan

Create Folders and Sub folders in it

Hi,

I have very huge data which I want to segregate and save in multiple files.

Same Data:

Country	City	Person	Age	Income
India	Delhi	Ram	28	1000
India	Delhi	Sita	27	900
India	Delhi	Mohan	29	980
India	Mumbai	Mohit	30	950
India	Mumbai	Misha	7	0
Australia	Sydney	Mark	20	200
Australia	Sydney	John	18	150
Australia	Perth	Micheal	45	5000
Australia	Perth	Eric	38	2500
Australia	Perth	Colette	15	350
Australia	Melbourne	Isable	21	600
US	New York	Mark	26	750
US	Washington	Jack	29	800
US	Washington	Mike	24	500
US	Seattle	Simon	36	3500
US	Seattle	Jack	41	4700
US	Chicago	Kelvin	27	550
US	Chicago	Imran	33	1100
US	Chicago	Andy	55	650

First I want to create folder with "Country" name. Each "Country" folder should have sub-folder with "City" names. Then each sub-folder should have Files with "Person" name. Like below-

Kindly help me in creating a workflow for this.

Regards,

Mohit

@patrick_digan

Output

Run Command

Accepted answers

Emil_Kos

Hi @mohit9garg,

Apologies I needed to amend the workflow in order to make it work. It isn't so easy to change the version for the yxzp file.

So I amended the file in order to make it work.

Now the output file is \, not the temporary location.

You would need to change it here in order to suit your needs.

20200207-WriteExcels - no macro.yxmd

Emil_Kos

Hi @mohit9garg,

Apologies but I was thinking about what would be the best approach for this.

The easiest solution for me was just deleting all the old folders. You don't need them anyway and that way you will ensure that you will not get any errors.

The alternative solution that I was thinking of would be much more complicated. I was thinking about using the directory tool and make sure that I am creating only new files for the files that didn't exist and overwrite files for each xlsx that already exists.

I think it is just easier to delete everything and save the files once more.

Hope this will help you!

Delete.yxmd

All comments

patrick_digan

@mohit9garg See if the attached sample points you in the right direction. There are a couple different methods, but I think the render tool is the easiest if it can accomplish what you're after.

Wherever this workflow is saved, it will create the folders and subfolders and write each person's info out to their file. Hopefully you can tweak this for your needs.

testingfoldercreation.yxmd

Emil_Kos

Hi @mohit9garg,

I always use the CMD tool in order to create new folders.

Here you can find a link for a workflow that you can test:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-create-folders-and-output-excel-file/m-p/524847/highlight/true#M110947

This workflow now is using the temp folder so it should be changed to for example C:\Test\

After you will change it the workflow will create folders for each of the positions in this column:

After you will create those high-level columns you will need to create new folders within them and in order to do so, you will need to use the block until done tool to ensure that first, you will create new folders before you will move forward with the subfolders.

mohit9garg

@patrick_digan can we use it through Output tool. Render tool will take more time than Output tool, given no. of files are ~200.

Alteryx_Finland

Hi Patrick,

I have a workflow which creates 3 output files. However I want the flow to work in such a manner that after every run, it should able to create folder with the run date and move the output files inside that date folder. Is it possible to acheive this in Alteryx ?

Note: Flow can run multiple times in a day too.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703