I am having difficult with pivoting a dataset I have. There is a column which can contain one or multiple (thankfully preset!) strings of text separated by ;
My current result though is showing the aggregated columns headers, rather than splitting them. I thought setting the delimiter to “;” would solve this, but alas not. Below are screenshots of what I am trying to achieve vs what I have managed to achieve thus far.
Can anyone suggest a way round this? I’m sure it is something Knime can handle, I just can’t quite get my head round it at the moment. Thanks!
Hi @JWebb ,
simply add an additional dummy column so you can use the pivot node!
Have a nice day,
It still didn’t quite work, (it was keeping the concatenated attributes), however I think I managed it.
By splitting cells by ;, unpivoting and then pivoting.
It would be interesting though to see if that is a bit of a round-the-houses way of doing it and there is a simpler way.
Are you trying to achieve the table in the upper right of your image or the one in the lower left?
If the first, I misunderstood the task. But glad you solved the issue
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.