Alteryx Designer Desktop Discussions

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

Combining multiple rows with common fields

ltensmeyer
8 - Asteroid

I'm trying to find the most efficient way to take information like this:

First Name    Last Name  Details

EthanKleinDental Benefits
EthanKleinMedical benefits
EthanKleinFamily plan
LaurenMayFamily plan
Lauren MayMedical benefits
Lauren MayHome benefits
Lauren MayDental benefits
Lauren MayChildcare benefits
JacobHoranDental Benefits
JacobHoranMedical Benefits
JoshForbes

Medical Benefits

 

and create one row for each person, combining each of the different details into one chunk of text divided by commas. 

The goal is to get something like this:

First Name Last Name Details

EthanKleinDental Benefits, Medical Benefits, Family Plan
LaurenMayFamily plan, Medical benefits, Home benefits, Dental benefits, Childcare benefits
JacobHoranDental Benefits, Medical Benefits
JoshForbesMedical Benefits

One of my bigger problems is the fact that each person will have a different number of rows, so I can't just set a number of rows to combine, I have to check and make sure the first and last names are matching.

Any ideas are appreciated, thank you!

 

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora

@ltensmeyer ,

"Concatenate" Action in Summary tool may work for you.

Input Data

Yoshiro_Fujimori_1-1678061591313.png

Configuration in Summary Tool

Yoshiro_Fujimori_0-1678061565695.png

Output Data

Yoshiro_Fujimori_2-1678061615039.png

 

Labels