Forum Discussion
Removing Duplicated to create a relationship!!!
Community ChampionYou must have a 'close' match. I would recommend (with such a small dataset) that you simply use the drop down arror for the column and scroll down it to see if you have any matches without capitol letters or spaces. I know you shouldn't have to and I know it is tedious but the last time this happened to me, it was picking up a couple of blank rows and another time, the words matched but the case did not.
I simplified the numbers for explanation sake. I have 7,904 rows and 7,902 distinct :(
Go to your query and select that job title column. Go to the Transform Tab and hit the Format menu (middle of the ribbon, near Split Column), and select Capitalize Each Word. Then remove duplicates. If kcantor is right that will probably catch them. You may also have to pick Trim from the same menu if the problem is an extra space character.
Side question: holy moly, does everybody in this company have their own unique job title?
Hahaha seems so ! Thanks for the help thus far both.
Transform trick did not work... :(
I can't understand how following these steps I don't get a unique list:
1. Duplicate original table in PowerBI query editor.
2. Delete all but job titles columns
3. Apply every kind of removed duplicates, removed blank rows, removed errors, Filtered> removed empty.
What else can I do?