Merging certain columns in duplicate rows.

Question

Hi,

I am wondering if a workflow would be possible to solve this.

I want to merge a certain column when a duplicate occurs. I have attached an image explaining what I mean, the top two rows are examples and the lowest row is the outcome I’d like. Obviously on a larger scale than this.

thanks.

Dan

C674DA13-A6F1-4DBD-946B-407CCC0A1A90.jpeg

BS_THE_ANALYST · Accepted Answer

Hi @DanMBrx! See the attached before and after picture.

You can achieve this with the summarize tool!

DataNath · Accepted Answer

Hey @DanMBrx, concatenating unique values is a good discussion and there's some ideas suggested for this on the forums. For now, here's a dynamic way of handling this that could also scale to N number of fields if you scale out rather than down:

ShankerV · Accepted Answer

Hi @DanMBrx

Please find the use case to explain it.

It will work on huge dataset also.

Please select Group By on the Column where you feel duplicates and use the Concatenate on the column to be merged.

The default will be separator , where it can be replaced with anyother as per would interest.

Many thanks

Shanker V