Create row as per column count

[Ajay_Chawda]

Hi
Can someone help me to achieve below scenario,

Consider input as records from database

Regards,
Ajay

[Ajay_Chawda]

Hello Experts,
Any suggestions …

[tstack]

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)