Unnesting in KNIME? Convert single row into multiple rows

Hi everyone,

I have current structure as:

image

I want to unnest the data in such form:

image

I have tried multiple ways but it doesn’t give the desired result. Can anyone please help me?

1 Like

Hi @jamalbutt1232,

could this be a solution?

Best regards
Andrew

4 Likes

Hey @jamalbutt1232,

It looks like @Andrew_Steel came up with the same solution I did. Here’s an attached workflow example for you:

ungrouping comma delimited data.knwf (7.8 KB)

image

It uses the Cell Splitter node to create a list out of your comma-delimited data and then uses the Ungroup node to convert those lists into rows (the data from other fields will be duplicated).

Cheers,

@sjporter

5 Likes

Yes, I was actually missing ungroup node. Now I know. Thank you!

1 Like

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