Skip to main content
  • EN

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

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

Reply


Community Stats

30,166
Posts
114,516
Replies
37,821
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.