As from the title, im trying to figure out how to recreate the JMP split function in KNIME.
So this is my data
And after running the split function, i need it to come out like this
The function it ran was this
So basically what im trying to achieve, is that i want to split a specific column (Version) , and the data in that column will be transposed as the column headers. And the Date and Tool column are the split values that will be filled under the new columns.
This is very close to what a pivot might do, but it doesnt actually split a specific column value and portray it as column headers where i can decide which column values i like to filled it with. Any help will be much appreciated.
you were almost there. Using the Pivot node is the way to go. Getting the settings right can be a bit tricky though. Have a look at the attached workflow. Key is to pick Version as Pivot, then Tool and Date as aggregation columns, and finally set the naming of columns to produce the required output. Split Column.knwf (82.3 KB)
Hi Nan,
Thanks, i guess i was having a mental block going about this. thanks for clarifying what i should have known before i posted this. Thanks again!
