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
6 - Meteoroid

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
6 - Meteoroid

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