Can someone help me to achieve below scenario,
Consider input as records from database
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)