Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

remove duplicate with condition


Recommended Posts

Hello,

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

Sincersly

Link to comment
Share on other sites

×
×
  • Create New...