+8Hi,
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
Best answer by erik_jan
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.
+19Hi @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.
+17Another 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
