Alteryx Output with Multiple Field

[Vicky92]

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

[morr-co]

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"). 

[Qiu]

@Vicky92 
As point out by @morr-co Alteryx will not allow duplicated field names.
However, we can do something about writing to Excel file, if that is what you need.
Latest Alteryx can have the option to preserve the format in excel as below.

Check the sample flow and see if it suits your requirement.

[Emil_Kos]

Hi @Qiu,

Really smart workaround! 

Clean and elegant I like it! 

[Qiu]

@Emil_Kos 
Thank you for the remark. 😁

[Qiu]

@Vicky92 
Appreciate you would remark the flow as accepted if you find it working for you.😁

[grazitti_sapna]

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.