How to change first row to be column header and delete second row

Jocelyn · October 28, 2019, 2:48am

Hi! I meet a problem. I read a excel file and process a little, then I want to use first row to be column header. Can I do it after excel reader?
Also how can I delete a row?
I draft what I want to achieve here.
Before:
Col1 Col2 Col3 Col4
1 2 3 4
a b c d

After:
1 2 3 4

Thanks a lot!!

mlauber71 · October 28, 2019, 5:25am

The insert column header node should be able to help.

A slightly different example as an inspiration
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_col_header

Experimenter · October 28, 2019, 6:15am

I would say

use partitioning node to split off the first row
apply transpose node to the split row and add it back as headers using aforementioned insert column headers node
use partitioning node again to split off the second row

Jocelyn · October 28, 2019, 6:24am

Thanks a lot for your help!!

system · November 4, 2019, 6:38am

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