A strange thing happened to me in Knime 4.7.
I needed to pivot a table from data.
In the data there is a date from which I derived the year and month.
Then I decided to do a pivot in the columns I put the numeric value of the month because it is a floating period so this period starts with 7,8,9,10,11,12,1,2,3,4,5,6.
I was surprised that the pivot key sorted it so nicely.
Then I took another part of the data from this set and performed some operations but in this case I don’t know why but the pivot table failed to sort the data as in the previous case but it was just 1,2,3,4,5,6,7,8,9,10,11,12
knime_forum pivot_ok and pivot_not_ok.knwf (69.5 KB)
is it possible to somehow force special sorting in Pivot yes I can do it expost but it seems to me unnecessary to add work if in one case it goes and in the other not .
I used to work on a big reporting sw IBM Cognos where I could sort columns by invisible column in pivot table
Unfortunately the data is sensitive and I think it’s in there , so I can’t share it .
I tried to mask them but now it’s a bit different the system did this