Reply
Frequent Visitor
Posts: 5
Registered: ‎06-14-2016

Re: Remove or Hide Duplicate Values

Thanks I will take a look

 

Frequent Visitor
Posts: 3
Registered: ‎02-16-2017

Re: Remove or Hide Duplicate Values

I have done this on a table but then when I try to join to another table on that field I get the error that I can't create the relationship as one of the columns must have unique values. Isn't applying that step getting me to where it's unique or am I missing a step?

Regular Visitor
Posts: 17
Registered: ‎06-08-2017

Re: Remove or Hide Duplicate Values

[ Edited ]

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)