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
Solved! Go to Solution.
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.