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!