@tarek_b21 maybe indeed you could provide us with an example. Or you could take a look at these examples on how to combine several nodes to handle Excel headers and cells.
What you can do is adjust the settings. You could tell KNIME to start reading data from line 4 and that the header is in line 3.
[image]
This would give you this:
[image]
If the structure of your tables does change you might have to be creative. You could first import the sheet ‘as is’ then identify the header line. Turn that information into a Flow Variable and use this line in informing the real import node where to start looking for header and data.
Well this can be done. Question is if indeed it would be easier to just rename the columns …
[image]
[image]