I need to separate the columns, but everything is more complicated than it seems

[BanS]

Hello, I need help with one task. I need to separate the columns, but everything is more complicated than it seems.

For example, I extract two columns from the database, ColumnA and ColumnB.

The ColumnA includes the data with a code, and ColumnB includes the product code.

Here’s an example:

I need to split the data with “;” so that the output is a table like this:

How can I do this using KNIME nodes? Perhaps I could do this with just a Java Snippet node?

[takbb]

hI @Bans, use Cell Splitter to split ColumnB with “;” as delimiter, and have it create a List

(you could also tick Remove input column)

Follow that node with an Ungroup node, and then Column Renamer and you should be done.

[hmfa]

Like this
TEST.knwf (73.9 KB)
Br

[BanS]

Thank you very much! It worked.

[hmfa]

Hi @BanS.
Please mark @takbb response as a solution.
Br.