One row to multiple columns

KNIME Analytics Platform
1

Hi people.

Can you helpme pease, to move or convert a row into multiple columns?
Example.

Row ID User name Profile User name Profile
ROW0 Alejandro Operativo Daniel Compras

I want to show:

Row ID User name Profile
Row0 Alejandro Operativo
Row1 Daniel Compras

Thanks.

2

Hi @Sand_Kob , it looks to me that you want the other way around, that is move multiple columns into multiple rows…

Can you show us what the real column names look like? I mean, you can’t have 2 columns with the same name. You can’t have 2 columns called “User name” and you can’t have 2 columns called “Profile”.

You can look into the Transpose node or the Pivoting node for moving columns to rows and rows to columns.

1 Like
3

Use the cell splitter node and choose as new columns for the output. Separator seems to be a space
br

4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.