Jump to content

remove duplicate with condition

SAMUT Fabrice

Recommended Posts


I used your expression :If(Rank(Rowid(),"asc",[Col_1],[Col_2],[Col_N])=1,"1st Record","Duplicate Record") to identify duplicate rows.

But now, I wonder if it's possible to add condition on duplicate rows to limit them.

Example on the attached picture:

the VIN numebrUU1K6720X61961350 is duplicate twice and I want to add 2 conditions to decide if I remove it or keep it

condition 1 &2 : milege between Duplicate Record and 1st Record > 50km & clip_date difference between 1st Record andDuplicate Record > 10 days

Thank you for your help


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...