Question

Last two records in a column

F

Hello all!

This seems like it should be a very simple thing to do but I am drawing a blank. I have an attribute column full of numbers (Dates). I just need to sort it and get the latest two records and put them under separate attributes. This is what the column looks like (already sorted descending).

I need to assign "170503" to one attribute (let's call it "DATE")

I need to assign "170331" to "previous_DATE"

Any help will be appreciated. Thanks!

4 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @fariyafarhad

I created a template file in 2017 and extract these informations using Counter, StatisticCalculator and TestFilter.

Please, see this template :)

Danilo

workspace-filter.fmwt

F

I managed to find the solution myself:

F

Hi @fariyafarhad

I created a template file in 2017 and extract these informations using Counter, StatisticCalculator and TestFilter.

Please, see this template :)

Danilo

workspace-filter.fmwt

Hi @danilo_inovacao thank you for your answer. I managed to find the solution right after I posted the question. Yours works pretty well too!

 

 

danilo_fme
Rank
Userlevel 4
Badge +30
Hi @danilo_inovacao thank you for your answer. I managed to find the solution right after I posted the question. Yours works pretty well too!

 

 

:) Good!

 

 

Reply


Community Stats

28,666
Posts
109,339
Replies
36,535
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.