Forum Discussion
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...
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.
Thanks augustindelaf the YouTube link you posted helped me emensely
You are Welcome Anonymous !