Sorter is not sorting by date/time but will sort manually

KNIME Analytics Platform
1

I’m confused why the sorter will not sort by date/time, but if I manually sort by date (by clicking the date column header) within the sorter output, then it will sort properly.

Here is the sorter and output, where you can see T011 and T012 are out of order.

image
image848×907 46.3 KB

Here is the same sorter output if I click the column header to sort.

image
image498×356 20.9 KB

For added context, here is the CSV import transformation.

image
image849×185 8.44 KB

I assume that I’m doing something wrong, but I’m not sure how to fix it.

3

Hi @gburleigh ,

it looks like there is a wrong default value set when using Date&Time values.

Follow these steps to set the node up correctly:

  1. Click on Show advanced settings
  2. At the criterion using the date&time column, set String Comparison to Lexicographic.

I added a +1 to the ticket (internal reference AP-23732) to have this unexpected default corrected.

Thanks for reporting,

nan

4 Likes