Hello,
I don't know the best way to go about this, I've been trying to set some conditional statements in my AttributeManager but I'm unable to get the results I'm after.
I'd like to identify the duplicate serial numbers (API NUMBER 10) in my data and then only keep the duplicate that has the most recent date (WELL STATUS DATE).
Thanks in advance for your help.
Best answer by ciarab
View original
+9
If you put the data through a sorter and order by your date attribute descending and then use the duplicate filter you should be left with the most recent date coming through the unique port
If you put the data through a sorter and order by your date attribute descending and then use the duplicate filter you should be left with the most recent date coming through the unique port
+17
Hi @ngstoke, you also have other choices. Assuming that the records have been originally sorted by API_NUM_10 and WELL_STATE_DATE ascending.
1. AttributeCreator + Tester
select a.*
from InputTable as a
inner join (select API_NUM_10, max(WELL_STATUS_DATE) as maxDate
from InputTable group by API_NUM_10) as b
on a.API_NUM_10 = b.API_NUM_10 and a.WELL_STATUS_DATE = b.maxDate
order by a.API_NUM_10
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.