DSXchange

Hi,

I am trying to use the following expression:

If RowProcCompareWithPreviousValue(Order_Details_in.OrderID) Then RowProcGetPreviousValue((Order_Details_in.UnitPrice- Order_Details_in.Discount)* Order_Details_in.Quantity) Else 0.

I want to create a total per Order ID in the target file - the stage Aggregator is not available - this is not a Parallel job.

My idea was to get the 'Result expected' but I am getting the OrderID numbers of the current rows - I don't know why.

OrderID | Unit | Discount | Quantity | Result expected | Result Returned
10 | 10 | 1 | 33 | NULL | 10
10 | 05 | 2 | 12 | 297 | 10
20 | 03 | 0 | 34 | 000 | 20
20 | 16 | 2 | 66 | 102 | 20
20 | 18 | 2 | 38 | 924 | 20

Thanks in advance,
regards,

Why do you claim that the Aggregator stage is not available?

With sorted input, an approach using stage variables in a Transformer stage is definitely viable.