Copy Values under cells

[aizazkhalid]

Hi,
I am very new to Knime. I need help to copy value under the columns.
I have this input:
Abc/Def
ABC/Def/GHI

I applied cell spliter and go the output like below:

I have another Excel reader that looks like below:

No I want to copy the values of cell splitter node under this row in second excel reader so it looks like this:

Is there a way to achieve this?

Thanks,

[knimediger]

Hello @aizazkhalid and welcome to the world of KNIME.

I’m not absolutly sure about the task you want to achieve. I assume that you would like to have a new header for your table with different column names.

You may want to take a look at the Column Renamer Node Column Renamer – KNIME Community Hub
Using that you can get the desired result.
Just ignore the ID column