ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Group Rows

cowannbell
コメット

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件の返信13
cowannbell
コメット

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

alexnajm
19 - Altair
19 - Altair
cowannbell
コメット

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

 

Thank you!

alexnajm
19 - Altair
19 - Altair

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!

ラベル
トップのソリューション投稿者