Aggregation By row-wise

[Prince_Hyd]

Hello Folks

I have a scenario similar to this

Source Target

Dept,sal Count
10,100 100
10,110 210
20,200 200
20,210 410

How to perform this.

Thanks

[prasson_ibm]

Hi,

Iit seems to be a interview question.
Please tell us that what you have attempted so far.

[Prince_Hyd]

Hello Parsson

I took one stagevar for deptno and given logic like this

StageVar = deptno

If deptno = StageVar Then S1+Sal Else Sal --------------- S1

but i'm not getting the expected result


Thanks

[asorrell]

I believe what you need are two stage variables:

1) svCount = If (incominglink.Dept = svDept) Then (svCount + incominglink.Sal) Else incominglink.Sal
2) svDept = incominglink.Dept


They must be in that order. svDept should be initialized to "".

[Prince_Hyd]

Hello Andy

Thanks for your solution, it worked perfectly!