Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Output with Multiple Field

Vicky92
7 - Meteor

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 NoNameClass I MathsClass II MathsClass III MathsClass IV MathsClass I EnglishClass II EnglishClass III EnglishClass IV EnglishClass I ScienceClass II ScienceClass III ScienceClass IV Science
1Vivek 108554748510855485108554
2Rahul529625599652962562529625
3Raghav624246624262424641624246
4Bahu8535855358535853853585
5Thjada95843946849584394849584394
6Veensa532748532532747453274
7Rajja621015951062101559621015
89John35301053035301062353010
100Rayne855215625285521535855215

 

Output 

 

  Class IClass IIClass III
S. NoNameMathsScienceEnglishMathsScienceEnglishMathsScienceEnglish
1Vivek 108585      
2Rahul526296      
3Raghav624142      
4Bahu85335      
5Thjada958484      
6Veensa57432      
7Rajja625910      
89John356230      
100Rayne853552      

 



6 REPLIES 6
morr-co
10 - Fireball

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
20 - Arcturus
20 - Arcturus

@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.1022-Vicky92.PNG

Emil_Kos
17 - Castor
17 - Castor

Hi @Qiu,

 

Really smart workaround! 

Clean and elegant I like it! 

Qiu
20 - Arcturus
20 - Arcturus

@Emil_Kos 
Thank you for the remark. 😁

Qiu
20 - Arcturus
20 - Arcturus

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

grazitti_sapna
17 - Castor

HI @Vicky92 , give this a try if it works for you.

 

grazitti_sapna_2-1603438227522.png

 

 

Result-

 

You can try to add more fields and then check as I tried to make it dynamic.

 

grazitti_sapna_1-1603438186133.png

 

If this helps, kindly mark this post as solution.


Thanks.

 

 

Sapna Gupta
Labels