Forum Discussion
Remove duplicates based on values
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.
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.
Is this the only way to do this? Looks like my data might be too large so it's not loading.
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.