Hi Team,
I want the output in Specific format. In other words consolidate the required output in specific field instead of creating output fields. I have to divide the column headers in respective columns
Input :-
S No | Name | Class I Maths | Class II Maths | Class III Maths | Class IV Maths | Class I English | Class II English | Class III English | Class IV English | Class I Science | Class II Science | Class III Science | Class IV Science |
1 | Vivek | 10 | 85 | 54 | 74 | 85 | 10 | 85 | 54 | 85 | 10 | 85 | 54 |
2 | Rahul | 52 | 96 | 25 | 59 | 96 | 52 | 96 | 25 | 62 | 52 | 96 | 25 |
3 | Raghav | 62 | 42 | 46 | 62 | 42 | 62 | 42 | 46 | 41 | 62 | 42 | 46 |
4 | Bahu | 85 | 35 | 85 | 5 | 35 | 85 | 35 | 85 | 3 | 85 | 35 | 85 |
5 | Thjada | 95 | 84 | 394 | 6 | 84 | 95 | 84 | 394 | 84 | 95 | 84 | 394 |
6 | Veensa | 5 | 32 | 74 | 85 | 32 | 5 | 32 | 74 | 74 | 5 | 32 | 74 |
7 | Rajja | 62 | 10 | 15 | 95 | 10 | 62 | 10 | 15 | 59 | 62 | 10 | 15 |
89 | John | 35 | 30 | 10 | 5 | 30 | 35 | 30 | 10 | 62 | 35 | 30 | 10 |
100 | Rayne | 85 | 52 | 15 | 62 | 52 | 85 | 52 | 15 | 35 | 85 | 52 | 15 |
Output
Class I | Class II | Class III | ||||||||
S. No | Name | Maths | Science | English | Maths | Science | English | Maths | Science | English |
1 | Vivek | 10 | 85 | 85 | ||||||
2 | Rahul | 52 | 62 | 96 | ||||||
3 | Raghav | 62 | 41 | 42 | ||||||
4 | Bahu | 85 | 3 | 35 | ||||||
5 | Thjada | 95 | 84 | 84 | ||||||
6 | Veensa | 5 | 74 | 32 | ||||||
7 | Rajja | 62 | 59 | 10 | ||||||
89 | John | 35 | 62 | 30 | ||||||
100 | Rayne | 85 | 35 | 52 |
Hello @Vicky92 : I don't believe this output is feasible in Alteryx. The main reason is that workflows cannot have duplicated column names otherwise they will be aliased to with a numeric suffix (i.e. "_2").
@Emil_Kos
Thank you for the remark. 😁
@Vicky92
Appreciate you would remark the flow as accepted if you find it working for you.😁
HI @Vicky92 , give this a try if it works for you.
Result-
You can try to add more fields and then check as I tried to make it dynamic.
If this helps, kindly mark this post as solution.
Thanks.