Skip to main content
Solved

Filter by most recent date


mr_fme
Enthusiast
Forum|alt.badge.img+9

Hi,

 

1I 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.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

takashi
Celebrity
  • June 22, 2020

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.


erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • Best Answer
  • June 22, 2020

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.


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • June 22, 2020

Thank´s


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings