can we delete the first row from the table?

KNIME Analytics Platform
#1

I am using transpose to transpose my data from row-wise to the column but in the output, I need to delete the heading row(first row) and want to make the next row as the heading.

#2

Use a row filter node

#3

@elsamuel Row filter not worked because it is the title row

#4

Some of the reader nodes have the option to skip lines of the input file. Maybe that is an option? Or you don’t read the header then remove the row and finally insert the column header using the insert column header node

Best
Mark

#5

Maybe you can take inspiration from this example that inserts new column heads:

#6

Perhaps it would be useful to use the Extract Column Header Node before transposing.
Then you could use Insert Column Header node to re-insert the headers as needed.

1 Like
#7

Hello there,

if I got it right values from first column should become column headers? After transposing table Row ID values become column headers so before transposing use RowID node to replace existing Row IDs with values from first column.

Br,
Ivan

1 Like
#8

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