Skip to main content
  • EN

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!

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

I managed to find the solution myself:

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!

 

 

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

30,141
Posts
114,392
Replies
37,776
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.