Replace/Simplify row values to eliminate duplicates

Yes this is due to using the whole line according to the entry_date. One could just use the Duplicate Row Filter and sort by last_contact descending and rejoin like with the largest purchase ever.

Or you could just do that within SQL (Hive) and select a FIRST or LAST VALUE like this:

so every line would get this value and you would have it if you filter to your chosen row:

1 Like