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.

Beckham's avatar
Beckham
Advocate II
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

How do you expand all the rows?