The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Group Rows

cowannbell
9 - Comet

I have a workflow that outputs rows where all the fields are the same but for three columns.  Network ID, Network Eff Date and Network Name

 

I want to only have one row output, where each network id, network eff date and Network Name are on the same row.

 

See Example attached.

 

What would be the best way to do this?

 
 

 

 

13 REPLIES 13
cowannbell
9 - Comet

I have never used the multirow formula tool before.  I get the grouping but how do you get a record id this way?

alexnajm
18 - Pollux
18 - Pollux
cowannbell
9 - Comet

I went with the tile method instead of record id.  I did use the rest of the process though.

 

Thank you!

alexnajm
18 - Pollux
18 - Pollux

Definitely another valid way - nicely done! If the question then is complete, go ahead and mark one of the responses as a solution. Thanks in advance!

Labels
Top Solution Authors