I am currently working on a project that I would like to drop an existing full row of column header to row 1 and in row 0 to insert a new row of column headers which each has a filter I could use from. For example for Formatkategorie it could be ^(16|20|21|46|48|65)$.
HI @tarek_b21 and welcome to the forum.
I’m not sure exactly what you’re trying to do - perhaps you could provide an example input and output dataset? The Row to Column Names node is one way to manipulate headers, but it sounds like you want some filtering functionality as well…?
Thank you for the help but it did not work. The target what I am trying to achieve is adding the data header as shown in the first screenshot to the knime workflow in the second workflow without damages rest of the data below.
@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.
as mentioned by mlauber71, if you can provide examples, it is much easier to suggest the best approach. the workflow here is just for giving an ideas to start.
KNIME_header.knwf (101.4 KB)