Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Merging Rows based on unique ID

Vsridharan
7 - Meteor

Hi , 

 

I have been trying to figure out a way to merge the data based on unique ID where if the data in a column for different records (with the same Unique ID) is different then merge the data separated by ";" however if the data is the same then just reflect that data as is.

 

I have attached a file that has a sample data of both the input and output to provide a better picture of the problem statement.

 

Would really appreciate advise on the best possible solution for the same.

 

Thanks,

V

4 REPLIES 4
CPSlater
6 - Meteoroid

Should be your answer.

Vsridharan
7 - Meteor

Hi @CPSlater,

 

Thank you for your response.

 

I am not sure if the file you uploaded is just an input file, because I am unable to see the solution.

 

Would be great if you could upload it again.

 

Thank you,

V

JosephSerpis
17 - Castor
17 - Castor

Hi @Vsridharan you can use the summaize tool to group your data based on Unique ID and concantenate the data.

 

Concatenate_29022024.png

CPSlater
6 - Meteoroid

Done - apologies!

Labels
Top Solution Authors