First Instance Comparison Logic

[kashif007]

How do I compare the data in the same table, the expected result is shown at the end:

Data from Legacy:
mtl bin qty sum plnt1 qty1 plnt2 qty2
1 A 4 4 2200 5 1200 8
1 B 2 6 2200 5 1200 8 split into two
1 C 2 8 2200 5 1200 8
1 D 5 13 2200 5 1200 8

I have stage variables to contain qty and qty1 sequentially.
The first instance where qty1 is less than sum split the qty into two. For example in record 2 when sum(6) is less than qty1(5) then split qty(2) into two records. In short, If qty is greater than remaining qty1 then split qty.

Finally records should look like the following
mtl bin qty plnt
1 A 4 2200
1 B 1 2200
1 B 1 1200
1 C 2 1200
1 C 5 1200

Please suggest.

[ray.wurlod]

Two outputs from Transformer with constraints qty1=qty1 (or simply unconstrained) and the other qty1<>qty2. Bring them back together with a Funnel stage if needed.