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?
Solved! Go to Solution.
@Emil_Kos The solution I was looking for.
Thank you 🙂
@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.
hey @soncoku
Not a problem, glad you could find a solution!
@grazitti_sapna This would work perfectly as well 😄 Thank you.
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 🙂
@soncoku , Welcome. We are always happy to help you and others facing challenges while solving their problems 🙂
@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!
Thanks @grazitti_sapna I think, you found best and easy solution...