Extract data the most recent week,month or year

KNIME Analytics Platform
#1

Hi everybody !

I have a CSV file witch contains data with date and others generated everydays, as below : 

I would like to have the possibility to select the latest data of the week or month or year.

I begin to extract the data of date as below but i can find solution :

Can you help me?

Thank you. 

 

#2

Hi Robunle,

You can do this by creating a new branch in your workflow starting with a Sorter node after the Date Field Extractor. In the Sorter node, you sort descending by week (or month or year). Next, use a Table Row to Variable node. This node will take the first row (which now has the max value) and convert it to flow variables.

You can then use the flow variable in the same way you used the quickforms in the screenshot you posted.

Cheers,

Roland