Skip to main content

Hi,

 

I have a table that has 2 fields, one with the name of cities and the other with the date. Features with the name of the same city are repeated, but the dates do not. How can I make a filter to use only each city but with the most recent date?

Eg. 

City | Date

DC     20200621

WD    20200619

DC     20200620

DC     20200619

WD    20200618

 

Thank´s

Hi @mr_fme, a possible way is: sort the features by Date descending with the Sorter, keep the first feature for each City with the DuplicateFilter.


Another option:

Use Sorter to sort by City, then by Date (descending).

Then use a Sampler to sample only the first feature (Group by City).

That should give the wanted result.


Thank´s


Reply