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.

augustindelaf's avatar
augustindelaf
Impactful Individual
9 years ago

very interesting way, thank you Beckham

Helped me a lot.

My problem seemed very specific but hopefully some other people like you managed to solve it.

that's great. 

thanks

 

  • ruthpozuelo's avatar
    ruthpozuelo
    Kudo Kingpin
    9 years ago
    Many thanks for the mention! /Ruth
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks augustindelaf the YouTube link you posted helped me emensely 

    • augustindelaf's avatar
      augustindelaf
      Impactful Individual
      7 years ago

      You are Welcome Anonymous !

  • Beckham's avatar
    Beckham
    Advocate II
    9 years ago

    That's GREAT!!! Thanks for the tip!