Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Remove Duplicates within Concatenated Cells

kat_osborn
6 - Meteoroid

Hi. I am trying to remove duplicates from a concatenated cell. I am using a summarize tool to concatenate and using \n 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!

5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @kat_osborn ,

 

Can you please post some data as an example?

 

M.



Bulien

kat_osborn
6 - Meteoroid

Here is a very vague example of what I am looking at. Let me know if you are needing anything more. @mceleavey 

mceleavey
17 - Castor
17 - Castor

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.



Bulien

kat_osborn
6 - Meteoroid

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. 

binuacs
21 - Polaris

@kat_osborn Something like this?

image.png

Labels
Top Solution Authors