Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Grouping Data by Field Value

krich434
6 - Meteoroid

Hi all - I have a set of customers who are owned by the same parent company (UDP Name) in my data set. I went to group them together by that UDP name, which is a field in my data set. 

krich434_0-1648582823947.png

 

Desired output:

 

krich434_1-1648582847904.png

 

Data set is attached. 


How can I achieve this grouping? I've tried Summarize but I don't think I'm doing it right, even if it is correct. Thank you all!

3 REPLIES 3
gabrielvilella
14 - Magnetar

Hi @krich434, here is one way of doing this.

gabrielvilella_0-1648584030160.png

 

krich434
6 - Meteoroid

Thank you - solved my problem. 

Subhamanyam
5 - Atom

This is brilliant. Thanks!

Labels