Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors