How to ungroup x-time

KNIME Analytics Platform
#1

Dear's

I just receive a file (*.xls) where row are already grouped. One column contain the number of initial row that are grouped.

Example :

Name Country Unit Number_of_entries

Jo Swiss CMDF 4

Dan Italy DFGC 5

What i need is :

Jo Swiss CMDF (1)

Jo Swiss CMDF (2)

Jo Swiss CMDF (3)

Jo Swiss CMDF (4)

Dan Italy DFGC (1)

Dan Italy DFGC (2)

Dan Italy DFGC (3)

Dan Italy DFGC (4)

Dan Italy DFGC (5)

i try the Ungroup node without success.....

Many thanks in advance

MitchP

#2

Hi Mitch,

this is more a data generation job :-)

You need to loop the data one row after the other (chunk loop start)

Than use the One Row to Many for multiplying your row.

Finally add a Counter node for the last new column.

I attached you a workflow which does exactly this.

 

Cheers, Iris

#3

Many, many, many thank's Iris....exactly what i'm looking for

;-)

Mitch