Data Reorganization: Separating Categories and Values in KNIME
Hello, I have a dataset with categories in one column and values in another column. Each occurrence is listed one after the other. For example:
Last Name; DUPONT
First Name; PAUL
Country: France
Last Name; DURAND
First Name; PIERRE
Country: SPAIN
I want to place the category as the header and each value on a separate line. I used the Rule Engine node to define the case, and I performed a pivoting node. As a result, I have my categories as headers, but all the values are in the same row, separated by commas. How can I put each occurrence on a separate line?