Create row as per column count

Can someone help me to achieve below scenario,

Consider input as records from database


Hello Experts,
Any suggestions …

I think you want to use the Pivot snap to convert the percentage data. You can then use a Join on the two datasets and a mapper to do the calculation.

I’m attaching a pipeline that demonstrates this approach:

RowAsPerColumn_2019_04_16.slp (10.9 KB)