Forum Discussion
Solved
Remove Duplicate data
Hello, I have an issue where I query a SQL DB and get back about 87k supposedly unique names. When I was trying to create a relationship I was notified that I cold not make a 1 to 1 relationship...
Hi! I had this same issue with emails! I managed to fix it by selecting the column in the Query Editor, right-clicking, and selecting transform->lowercase and then selecting Remove Duplicates. There's also an UPPERCASE option and a Capitalize Each Word option that might help!
Hi! I had this same issue with emails! I managed to fix it by selecting the column in the Query Editor, right-clicking, and selecting transform->lowercase and then selecting Remove Duplicates. There's also an UPPERCASE option and a Capitalize Each Word option that might help!
That did it!
So easy. Thanks!