Custom Sort on a Single Column

KNIME Analytics Platform
, ,
#1

Hi, I would like to sort a column in my table with the name of months in a specific order (i.e., Aug, Sep, Oct, Nov, Dec) so that on a bar chart the month of August is first followed by the rest.

Any idea how I can do this?

#2

Hi @SarahR & welcome to the KNIME forum community,

There are several ways of achieving this, for instance either with a string manipulation or by transforming the strings (Aug, Sep, Oct, Nov, Dec, etc.) into proper dates.

Could you please copy & paste here in text format a bit of your data so that we can take the problem from there and help you better ? Another way is to provide us with your data in Excel format. Thanks in advance.

Best
Ael

2 Likes
#3

You can use the Rule Engine node.
$Month$ = “Jan” => 1

$Month$ = “Dec” => 12

Then sort on the new numerical column.

#4

Extracting the Date / Month Number with the Node or use a mapping table similar to suggested
br