To read header in excel

I am trying to read one excel where i have two header and inside one header there are few subheader.


REPORT_DATA header contain few sub header.Attaching the screenshot.

Is there any way to filter REPORT_DATA COLUMN
so that automatically subheaders data under it also filter along with the sub header column name?

Currently only taxonomy_id is coming in sub header.attaching the screenshot for it as well.After using column filter node.

Using just KNIME you can get data based only on absolute column number no sub-headers.

1 Like

You could skip the first line and use the second one as header. Like in the example no 110 from my collection of Excel imports:

If you have very special needs concerning your header you could import the header line separately and use the insert column header node (no 115 of the collection):

1 Like

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