Copy Values under cells

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:
Screenshot 2024-03-14 154935

I have another Excel reader that looks like below:
Screenshot 2024-03-14 155058

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,

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

1 Like