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.
SOLVED

Grouping lines for different columns

TJeanty1
5 - Atom

Hello community, 

 

I need your help ! 

Basically I have an input see picture and I want to put the data from the different line on the top of each columns like in the output picture. 

 

An idea ? 

 

Thanks in advance ! 

4 REPLIES 4
vishwa_0308
11 - Bolide

Hi,

 

Please try the attached workflow..

 

 

Thanks,

Vishwa

 

 

 

BenMoss
ACE Emeritus
ACE Emeritus

This is relatively straight forward.

 

Start by transposing your data. This will give you a two column list. One column will give the column name, the 2nd column will give the value.

Then filter out lines which are NULL().

 

The next step would be to create a recordID which increases from 1 to n within each group; you can achieve this using the multi-row formula tool.

 

Finally you can then use the cross-tab tool to bring your data back in line, grouping by this new ID field, using the 'name' field as our header and the value field as our values.

CrosstabTranspose.png

 

Workflow attached.

 

Ben

LordNeilLord
15 - Aurora

Hey @TJeanty1

 

I'd go for this:

 

Grouping2.PNG

TJeanty1
5 - Atom

Thank you !!! 

Labels