Read a row and then create a new row/rows

Hi all,

I am very new to Knime. I was wondering if someone can help me on this matter:

 

I need a workflow to help me read a row and then create an additional row. Sometimes it might be more than 1 row.

For example:

Name

Product

Bob

Pencil

Sue

Pen, Pencil

Jen

Pen, Paper

   

Product

SKU

Paper

1

Pen

2

Pencil

3

The new table should be:

Name

SKU

Bob

3

Sue

2

Sue

3

Jen

2

Jen

1

Thanks ahead everyone!

Carol

Hi Carol,

you need to change the product into multiple rows. you  need to convert the cell containing (Pen,Pencil) in multiple columns or in a collection column (See here:https://www.knime.org/blog/collection-cookbook)

You can use the cell splitter to split into multiple columns and afterwards you can use the unpivotiing node to rotate them into many rows.

You can afterwards join the produkt/SKU Table.

A good introduction into KNIME is our online course which you can find here: https://www.knime.org/knime-introductory-course

Best, Iris 

Thank you so much Iris!