Forum Discussion

QuasemS's avatar
QuasemS
Frequent Visitor
10 years ago
Solved

Remove duplicates based on values

Hi,   I'm trying to remove rows based on duplicate values in a column. I know how to use the Query Editor to do this. However, the duplicate values in that column has different values corresponding...
Need Help
  • Beckham's avatar
    Beckham
    10 years ago

    I've had this problem before. I'm using datesThe way I found around it was 4 steps:

     

    Step #1. Use group by to find the max value. Add all rows to the bottom.

     

    Step #2. Expand all the rows. Basically this adds a new column with the max values down the side of the table

     

    Step #3. Add a custom column like this:  if date_applied = Max Date then true else false

     

    Step #4. Filter down to just true. 

     

    Hope this helps.

pkumar's avatar
pkumar
Frequent Visitor
9 years ago

Is this the only way to do this? Looks like my data might be too large so it's not loading.

PBI_KLo's avatar
PBI_KLo
Helper I
9 years ago

Even if you didn't add the extra test, the grouping would by default eliminate the non-grouped subset. At least that's what I'm seeing with my dataset. I have a group of users who purchased items at different dates. I wanted to look for their earliest order date, so I grouped a "Min" on the order date and was left with that.