I am new to KNIME and looking for help on a sorting issue. I have a table with a column of type string with a dozen nominal values. I use the “Edit Nominal Domain” node to give a suited sorting order to the domain values. However, when I apply the “Pivoting” node and use the a.m. column as a group column the pivot table output comes in lexicographical sorting. I have not found a way to get my defined sorting order. Also the “Sorter” node seems to be of no help.
thanks a lot for your quick reply. When I check the “Retain row order” option the resulting table has a more or less random row order - probably driven by the unsorted input table. So, unfortunately this does not solve the issue.
as a workaround you could try to prefix your Strings with letters and an underscore such that the lexicographical ordering of the Strings would yield your order (e.g. ‘a_’, ‘b_’, ‘c_’ and so on). This could be done e.g. using the Rule Engine or the Column Expressions nodes. Afterwards, you can chop off everything before the underscore to get the original Strings.
From a more general perspective it seems that the settings done in the “Edit Nominal Domain” node currently cannot really be employed further downstream when it comes to sorting.