Hey, guys. I have an excel and it has merge cells. When I run the excel reader, knime places the columns to the right of the merge as null. Any help on how I could change for him to repeat the name on the others as he does on the first? Or how can I enter the value of the first ones on the right? [Untitled]

Well this can be done. Question is if indeed it would be easier to just rename the columns … [image] [image] [image] construct new header from 2 lines in imported excel file – mlauber71 construct new header from 2 lines in imported excel file

Excel Reader Merged Cells

KNIME Analytics Platform

mlauber71 June 30, 2020, 2:42pm 3

Well this can be done. Question is if indeed it would be easier to just rename the columns …

2 Likes

How to merge excel columns

arff file data table column name missing

drop down row column header and put new one with a filter

To read header in excel

whitespace in excel headers