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

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.
Col1 Col2 Col3 Col4
1 2 3 4
a b c d

1 2 3 4

Thanks a lot!!

The insert column header node should be able to help.

A slightly different example as an inspiration


I would say

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

Thanks a lot for your help!!

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