Forum Discussion
Removing Duplicates is not removing all duplicates.
Hello, I have a single column table that I have appended two tables to create. I then used the 'removed duplicates' option in the column dropdown. However, and this took me forever to find, but for some reason there are STILL 3 sets of duplicate values still in the set after doing this.
Do anyone know why these wont be removed?
2 Replies
Hi baaaailey ,
I'll give it a shot. Could it be that there are lagging spaces?
Before:
After remove duplicates:
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/I dont think so no, I did some trim and then LEN on both the original and the trimmed version and the number of characters are the same.
