Skip to main content
Question

Last record with a value based on date

  • Jul 15, 2021 11:41 AM UTC
  • 1 reply
  • 223 views

darkspatiallord
Supporter
Forum|alt.badge.img+8

I have a series of records - each is then replicated multiple times by date and then have andother column with either a value or null. each also has a unidue key based on the geom.

not every date has a value and thus in null.

what i need to search for is for each unique geom find the record that has the latest date with a value in the extra field.

needs to return one record per unique id

any help appreciated

1 reply

jkr_wrk
Influencer
Forum|alt.badge.img+37
  • Jul 15, 2021 6:43 PM UTC

Tester to test for the existance of the value. Sorter to sort on date. Sampler to sample the first. Or a matcher, or duplicateFilter.