I am new on KNIME, and still learning a lot. But I seem to be stuck a bit with a simple sorting/subtraction problem.
I have the following example:
1- I would like to make my table having the “C” row always coming as the first row (after the header). I saw the sorting function, but there I could just sort according to ascending/descending order, and not a specific string.
2- I would like to perform, in a new appended column, the subtraction of the values in reference to the “C” value.
I believe that making the column “value” variables, and them performing math formula (variable), but how to add it in the same row the subtraction values?
If somebody have some helpful insight/guidance, it would be terrific!
what would be string specific sort? As a workaround you can use Rule Engine to to create new column based on which you perform desired sort. For example if value is “C” in new column have value 1 else have value 0 and sort descending.