Rename a column that is just after a specific one
Hi,
I import some extract from a SAP Frontend into Knime and for some column the “ID” is in a column and the “Text/Description” in the column just after.
The ID column has the right column header, but the “Text/Desciption” doesn’t have any header (if you open the excel file, the header is merged on the two column).
I have several column like these, and I’m wondering how you would solve it.
The new column name could be the same as ID one with “+ Description” for example. Change by position is not possible because column are not always at the same position.
I was thinking about a “Column Expression Node” that would check column header 1 by 1 and if the name start with “Column_*” then take the name of predeccessor colum and add " Description" as new column header but I don’t think we can rename header with this node.
Maybe Javascript node, but I don’t know Javascript at all…