Is there an easier way to change the ordering and sorting in a GroupBy node?
I have a table where I wanted to group and sort by two different columns. Unfortunately, the first column I want to group / sort by is the last column in my data set, so when I use the GroupBy node it is always on the bottom. KNIME sorts by the earlier column first which I want it to be sorted on later.
Basically what I am looking for is to recreate a SQL query that is something like
Select, sum(a), b, c
group by c, b
(Sorry if that makes less sense, my SQL is rusty)
The only way I can see to do this in KNIME is to either use the Column Re-sorter node before I use the GroupBy node, or to us it afterwards and then also use the Sorter node to get the rows in the correct order.
Is there any easier way to do this? It seems awfully clunky when it would be much easier to simply be able to change the order of the columns in the GroupBy node and not have to use any other nodes.