topic How to get all duplicates in 1 list in Alteryx Designer Desktop Discussions

How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 11:30:23 GMT

Hey everyone.

I have this long list of name where I have duplicates (sometimes even 9 repetitions of the same name).

If I use the duplicate tool it does give me the duplicates but it keeps one in the list of the Unique results.

For example:

1. England

2. Spain

3. England

4. England

5. England

The Unique tool would give me this result :
Unique: Englad, Spain
Duplicate: England, England, England

What I want to achieve is to have all records that are repeated in 1 list.

Like this:

Unique: Spain
Duplicate: England, England, England, England

Any ideas?

Re: How to get all duplicates in 1 list

JosephSerpis — Fri, 09 Oct 2020 11:43:22 GMT

Hi @soncoku I mocked up a workflow that showcases how to do that. Let me know what you think?

Re: How to get all duplicates in 1 list

Emil_Kos — Fri, 09 Oct 2020 11:37:04 GMT

Hi @soncoku,

probably not most efficient solution but it works.

Re: How to get all duplicates in 1 list

atcodedog05 — Fri, 09 Oct 2020 11:41:50 GMT

Re: How to get all duplicates in 1 list

TheOC — Fri, 09 Oct 2020 11:41:03 GMT

Hi @soncoku ,

I managed this with two summerize tools, please find attached my workflow of how this was done:

I ran with this input:

and ended with an output as you asked:

Let me know if i can help any further!

Re: How to get all duplicates in 1 list

grazitti_sapna — Fri, 09 Oct 2020 11:38:52 GMT

Hi @soncoku , give this a try.

Thanks.

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 11:40:36 GMT

@atcodedog05 I use the Unique tool everyday but it doesn't help me with this situation 😕

Re: How to get all duplicates in 1 list

atcodedog05 — Fri, 09 Oct 2020 11:47:34 GMT

@soncoku Sorry my bad didnt read completely. My approach would be similar to @TheOC

My system is having issue. Guess got to fix that😶

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 11:50:39 GMT

@TheOC good one but you concatenate everything in one cell.

I reality I have a list with +1000 rows with at 47 cols, that doesn't make my job easier 😛

Re: How to get all duplicates in 1 list

TheOC — Fri, 09 Oct 2020 11:52:02 GMT

oh, i can adjust that no problem! How would you like it to output specifically?

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 11:57:51 GMT

@Emil_Kos The solution I was looking for.
Thank you 🙂

Re: How to get all duplicates in 1 list

atcodedog05 — Fri, 09 Oct 2020 11:58:48 GMT

Hi @soncoku

My take on this

Output 1:

Output 2:

Hope this helps 🙂

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 11:58:59 GMT

@TheOC thank you very much for the time and effort. @Emil_Kos solved it

Re: How to get all duplicates in 1 list

grazitti_sapna — Fri, 09 Oct 2020 12:04:41 GMT

@soncoku , I thought you were looking something for solution like you mentioned in your post anyways I have an easier approach if it helps.

Thanks.

Re: How to get all duplicates in 1 list

TheOC — Fri, 09 Oct 2020 12:05:43 GMT

hey @soncoku
Not a problem, glad you could find a solution!

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 12:10:32 GMT

@grazitti_sapna This would work perfectly as well 😄 Thank you.

Re: How to get all duplicates in 1 list

soncoku — Fri, 09 Oct 2020 12:15:04 GMT

I want to thank you all for taking the time and effort to help me with my problem. You're the best 🙂 .
Alteryx, in my opinion has one of the best community support groups 🙂

Re: How to get all duplicates in 1 list

grazitti_sapna — Fri, 09 Oct 2020 12:16:56 GMT

@soncoku , Welcome. We are always happy to help you and others facing challenges while solving their problems 🙂

Re: How to get all duplicates in 1 list

TheOC — Fri, 09 Oct 2020 13:14:13 GMT

@soncoku

You are more than welcome! The Alteryx community is fantastic! If you ever need anything else feel free to make another post or my inbox is always open!

Have a great weekend!

Re: How to get all duplicates in 1 list

acaryasin01 — Wed, 14 Jul 2021 07:48:07 GMT

Thanks @grazitti_sapna I think, you found best and easy solution...