Remove Duplicates within Concatenated Cells

Question

Hi. I am trying to remove duplicates from a concatenated cell. I am using a summarize tool to concatenate and using 
 as the separator in order to have the concatenated fields have each one on a separate line.

Is there a simple way to remove the duplicates?

Thank you!

binu_acs · Answer

@kat_osborn Something like this?

Remove_Dup_060923.yxmd

kat_osborn · Answer

Yes, this is after they have been concatenated. The unique tool is not working before the summarize tool for some reason. I did not know if there was a way to do it after. There's no reason as to why, that's why I was asking if it was possible.

mceleavey · Answer

Hi @kat_osborn ,

I'm assuming the example you gave was AFTER you've done the work described above? So this is after you've concatenated? If that's the case why not simply use a unique tool before the Summarise tool?

Do you have an example of the data BEFORE you concatenate? Is there a reason you're concatenating with the duplicates THEN trying to remove it?

M.