+1Hello,
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
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
+9If 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
+1If 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
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