Manipulating data on different columns

Hi Community,

I have a set of data that has some countries set together in the same cell with “,” as separator.

What I need is to have the data in the other to be duplicated with each country code on a separate row.

I know that I can separate the countries in different columns via “Cell Splitter” node, but this will make the data much harder to manipulate.

Can anyone help me with this?

Hi @MRKoura and welcome to the KNIME forum

The Cell Splitter is a good start. When you selected “As List” for the output, you can UnGroup this lis, and duplicate your records. See this example workflow Manipulating data on different columns.knwf (13.8 KB)
Screenshot from 2020-03-05 12-20-56
gr. Hans


Thank you this was so helpful :slight_smile:

1 Like

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