hello everyone,
i am new to the platform, i would like to ask for some help.
i have an excel file where i have all the data in one column like this:
Mark
value A
4
value B
2
Alice
value A
7
value B
1
…
I would like to create a table on KNIME of three columns: Name, value A, value B
in this example the first row after the header: Mark, 4, 2
can anyone tell me the easiest way to do this? thank you very much
Hi @BackupArian
Try this workflow, which breaks out the different row groups using chunk loops and builds the table.
Split single column into table.knwf (2.1 KB)
3 Likes
Hi @BackupArian
If you are looking for the easiest way to do this, then check Create a table from one column.knwf (36.1 KB)
gr. Hans
3 Likes
Thank you so much. how do I add the column header first? in Row ID I already have “Mark”, you manually put “column1”, how do I move the whole column down one row?
Hi @BackupArian , so you currently have “Mark” as the column name instead of row1?
OK, well since you said you are reading this from Excel, configure the Excel Reader so it doesn’t take column names from the first row:
Alternatively, on this occassion because we are dealing with a simple Column, you can do this:
Which will place the column name in the first row of a new column called “Column 1”, with the existing rows beneath that
3 Likes