Forum Discussion
Need help with removing duplicates
Hello everyone, I've got this table with duplicates, but when I add the "remove duplicates" step in Power Query, it removes the wrong rows. Here's an example of the table: Pay attention ...
Ok, so you have two options:
First one, you sort the status column in ascending order, so if you remove duplicate in maia.Persoon.cd_rate you would keep the minimum values of status,
Second option, you can create a key column, then duplicate the table to keep the key column and the two columns we had (maia.Persoon.cd_relatie and status), and then group by minimum value and combine this table with the other table by the key column.
If you have problems tell me @LaZZaNoVa-61
The first option is what I've done, but it is not working.
The second option is something I have not tried out yet.