Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Group Multiple values from different rows into one row based on common identifer

Masond3
8 - Asteroid

Hi Team, 

 

This is hopefully a easy ask 

 

Where there are multiple entities (Rows) for a given "Comp Id" then append the names from the different rows  together (Separated by a semicolon )  against a given Comp ID

 

Input 

 

Comp IDName
11111John Doe
11111Silver Fox
22222Grey Goose

 

Expected Out put 

Comp IDName
11111John Doe ; Silver Fox
22222Grey Goose

 

Looking forward to your help 

 

Many Thanks 

Regards

Masond3

4 REPLIES 4
ShankerV
17 - Castor

Hi @Masond3 

 

You can achieve your goal by Summarize tool.

 

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Masond3 

 

Output:

ShankerV_0-1669899091712.png

 

 

Summarize tool- 

 

ShankerV_1-1669899106575.png

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @Masond3 

 

Very important, usually the concatenate Separator in default will be ,

Kindly modify as ; to get your output.

 

ShankerV_0-1669899258959.png

 

Kindly accept this solution if it provided a solution to your question.

 

Many thanks

Shanker V

 

Masond3
8 - Asteroid

I was trying to do this in cross tab :) 
Thanks the pointer - really appreciate it 

Labels