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

Combine multiple rows into one row

nexbelgium
6 - Meteoroid

Hi,

 

I would like to combine records that I receive in multiple rows into one row.

 

In short, this is my input:

UserNameMichael
StatusActive
TeamSales
LocationFrance
UserNameThomas
StatusNot Active
TeamHR
LocationBelgium
UserNameBob
StatusActive
TeamHR
LocationSpain

 

And this is the what I would like as output:

UserNameStatusTeamLocation
MichaelActiveSalesFrance
ThomasNot ActiveHRBelgium
BobActiveHRSpain

 

It's a kind of transpose on the 4 first rows to be repeated. If it were only 2 'columns' per record, I could do that with the multi-row formula, taking the [row-1], but the more columns I add per record, the more complex it becomes.

 

Many thanks

2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

Hey @nexbelgium! The key is to add a field that you can group by before cross-tabbing. Try the attached workflow and see if that's what you're looking for. Hope this helps!

nexbelgium
6 - Meteoroid

Great, thanks it works! 

Labels