How to remove duplicates

Question

I have duplicate ticket fields in my database & I want to remove the duplicates that have older dates. E.g:

CustID | Date

AM10000 | 1/1/2017

AM10000 | 1/1/2018

GK17010 | 1/1/2018

so I want the answer to be

AM10000 | 1/1/2018

GK17010 | 1/1/2018

Answer 1

Create a calculated field [Rank - Date] with below code:

RANK_UNIQUE((MAX(SPLIT([database field],'|',2))))
//This will create a values for every ticket

Now do this, to filter only date with max value and drag to filter and select True

[Rank - Date]=1

I guess this should work