How to create rows and split services

Hi, i need help with the next problem pls.

I want to add more rows with a determine service. for example i have de next table.

|id|name|serviceCatergory1 |serviceCatergory2 |
|1|harold|service1,service2 |service5,service6 |
|2|mario |service1 |service4,service5,service6|

i want to generate the following result table:

|id|name|serviceCatergory |value|
|1|harold|serviceCatergory1|service1|
|1|harold|serviceCatergory1|service2|
|1|harold|serviceCatergory2|service5|
|1|harold|serviceCatergory2|service6|
|2|mario|serviceCatergory1|service1|
|2|mario|serviceCatergory2|service4|
|2|mario|serviceCatergory2|service5|
|2|mario|serviceCatergory2|service6|

In a nutshell i want to unpivoting but i want also separate the services by comma and optimize the workflow why this will be procesing more than 50000 rows. Thanks

Hi @bellyoz -

Here’s an example that works for your case. If you end up adding more category columns, you’d just need to add in additional Cell Splitter nodes to the workflow.

As usual with KNIME, there’s probably a more elegant way to do this! But I hope it helps.

2018-07-23%2013_27_42-Window

SplittingUnpivotingExample.knwf (14.3 KB)

1 Like

Woww , this is i want need thanks.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.