Merging Rows based on unique ID

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

Designer Cloud

Macros

Accepted answers

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

Concatenate_29022024.yxmd

Done - apologies!

Query response re saved.yxmd

All comments

Should be your answer.

Query response.yxdb

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

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

Concatenate_29022024.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703