Program | Location | Weekday | Start Time | End Time | Duration | Freq | ABC1 | ABC2 | ABC3 | ABC4 | ABC5 | ABC6 | ABC7 | ABC8 | ABC9 | ABC10 | ABC11 | ABC12 | ABC13 | ABC14 | ABC15 | ABC16 | ABC17 | ABC18 | ABC19 |
Program1 | Location1 | Mo | 18:00:00 | 18:30:00 | 30 | 8 | 108.30 | 84.60 | 87.00 | 129.60 | 64.80 | 96.50 | 66.60 | 122.00 | 73.40 | 112.60 | 84.90 | 109.40 | 103.90 | 83.50 | 163.50 | 151.20 | 120.70 | 164.20 | 65.60 |
Program2 | Location2 | Tu | 18:00:00 | 18:30:00 | 30 | 17 | 131.00 | 87.60 | 79.70 | 105.90 | 61.60 | 73.10 | 71.90 | 94.50 | 80.00 | 88.70 | 91.10 | 108.60 | 91.50 | 85.30 | 158.00 | 133.70 | 98.60 | 146.40 | 71.20 |
Program3 | Location3 | We | 02:00:00 | 03:00:00 | 58 | 13 | 121.30 | 66.90 | 92.80 | 64.10 | 69.40 | 68.40 | 107.20 | 62.90 | 87.70 | 68.00 | 74.30 | 95.00 | 66.90 | 103.60 | 117.50 | 103.00 | 65.60 | 76.30 | 89.50 |
Program4 | Location4 | Mo | 25:24:00 | 26:00:00 | 36 | 1 | 114.50 | 86.70 | 95.40 | 75.70 | 73.60 | 71.50 | 108.50 | 75.50 | 90.70 | 79.70 | 93.40 | 101.50 | 74.90 | 108.20 | 132.30 | 114.60 | 80.30 | 84.60 | 107.10 |
Program5 | Location5 | Fr | 20:00:00 | 23:00:00 | 180 | 2 | 104.00 | 144.90 | 116.90 | 79.40 | 114.70 | 87.40 | 111.70 | 114.10 | 101.90 | 122.20 | 132.20 | 94.00 | 108.30 | 98.20 | 117.30 | 129.00 | 89.60 | 91.70 | 148.40 |
I have a table above in Excel. I would like split this table in a way that Columns from 'Program' to 'Freq' remains in all tabs but ABC1 Tab should have only ABC1 in addition
Program | Location | Weekday | Start Time | End Time | Duration | Freq | ABC1 |
Program1 | Location1 | Mo | 18:00:00 | 18:30:00 | 30 | 8 | 108.30 |
Program2 | Location2 | Tu | 18:00:00 | 18:30:00 | 30 | 17 | 131.00 |
Program3 | Location3 | We | 02:00:00 | 03:00:00 | 58 | 13 | 121.30 |
Program4 | Location4 | Mo | 25:24:00 | 26:00:00 | 36 | 1 | 114.50 |
Program5 | Location5 | Fr | 20:00:00 | 23:00:00 | 180 | 2 | 104.00 |
ABC2 tab should have only ABC2 in addition.
Program | Location | Weekday | Start Time | End Time | Duration | Freq | ABC2 |
Program1 | Location1 | Mo | 18:00:00 | 18:30:00 | 30 | 8 | 84.60 |
Program2 | Location2 | Tu | 18:00:00 | 18:30:00 | 30 | 17 | 87.60 |
Program3 | Location3 | We | 02:00:00 | 03:00:00 | 58 | 13 | 66.90 |
Program4 | Location4 | Mo | 25:24:00 | 26:00:00 | 36 | 1 | 86.70 |
Program5 | Location5 | Fr | 20:00:00 | 23:00:00 | 180 | 2 | 144.90 |
Is there a way to do it in Alteryx?
Solved! Go to Solution.
See attached! If you Transpose the data first so that all the ABC's are in one column with their respective values next to them, you can then indicate in your Output tool that you want to create a new tab for each ABC value. Just check the box at the bottom of the configuration for the Output tool and indicate Change File/Table Name based on the value in the Name column in your data.
Does that help point you in the right direction?
Cheers,
NJ
Thanks Nicole. It worked perfectly.
Is it possible to sort the ABC# columns in each tab after exporting within the same workflow?
Figured out a way to sort. Applied sort before export. Thank you.