Forum Discussion
Solved
Remove or Hide Duplicate Values
Is there a way to Remove or Ignore duplicate values when they occur in a column? I'm pulling data from our SQL Server. I have 2 related tables. Every once in a while a duplicate value will occur ...
There is a Remove Duplicates step when editing your query, it is in the Reduce Rows section of the ribbon, the M code is:
#"Removed Duplicates" = Table.Distinct(#"[Previous Step]", {"[Column Name]"})
There is a Remove Duplicates step when editing your query, it is in the Reduce Rows section of the ribbon, the M code is:
#"Removed Duplicates" = Table.Distinct(#"[Previous Step]", {"[Column Name]"})
Using Table.Distinct, which rows are kept (not removed)?
For instance, if I try to remove duplicates based on a "user_id" column, the first row with each user_id will be kept, and the following rows with that user_id will be removed? (wondering if I need to sort before to make sure I keep the rows I want to keep)