02-16-2017 01:20 PM
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?
06-28-2017 06:26 AM - edited 06-28-2017 06:34 AM
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)