Question

Last record with a value based on date

  • 15 July 2021
  • 1 reply
  • 24 views
darkspatiallord
Badge +6

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
Rank
Userlevel 3
Badge +18

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

Sample: Every Nth Feature (N=1)

Reply


Community Stats

28,731
Posts
109,527
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.