Unpivot based off a field

KNIME Analytics Platform
1

Hi all - 

Was wondering if anyone had tips on turning "Seat block" data into individual seat data, ie we get purchase data based on someone buying, say 4 seats together.  I would like to turn the data into a one row per seat dataset.  

The attached shows the before and after I was hoping for.  

Any help would be greatly appreciated.

Thanks!

 

 

2

Hi, I made you an examplary workflow. I only use the start seed number and the number of tickets for the generation. I hope this helps.

Best, Iris