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!
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