Ranking and filtering the highest rank

[Skirpichnikova_Ksenia]

Hi, I have data for a few months (column Period) and in excel a user filters the last month and works with it.
I have a question how I can do the same in knime if the user does not have an access to a workflow.
One solution I see is that I can add ranking to to column Period (JAN has rank 1, FEB has rank 2 and so on), then I can filter the highest rank (in my case it is DEC) and work further with data for DEC. There is one problem that this column has indication of a year as well and year will change. Can someone help me with such a workflow or propose any other solution?

Period	Amount
JAN20	10
FEB20	24
MAR20	455
APR20	566
MAY20	526
JUN20	669
JUL20	99
AUG20	99
SEP20	88
OCT20	812
NOV20	5484
DEC20	546

[Snowy]

Can you simply change the way your period is formatted? Instead of Month-Year, can you format it as Year-Month? E.g. 202001 (Jan 2020), 202002 (Feb 2020), 202003, 202004… etc. Then just sort in descending order.

There may be a way to use the String to Date&Time node to parse the way you have your Period currently formatted, but I was unsuccessful. Perhaps someone else can provide the proper date format conversion.

Otherwise, yes, you can use the Rule Engine node to create another column and sort off that column. Something in the rule engine like:

should work fine.

[Skirpichnikova_Ksenia]

Hey, thanks for trying! I need also to remember that next year values will be JAN21, …21 and so on and my workflow should be still robust.

[Snowy]

Try using the Cell Splitter By Position node

Output:

You can then use these columns in conjunction with something like Rule Engine to get it into the proper format (Year – Month).

[Daniel_Weikert]

Maybe you could use the date&time input to get todays date and then filter your data based on that. This should adjust automatically each time you execute the workflow.
BR