I have source like this Num, SeqNo,Ln,Qty 101, 1 ,1,5 I wanna target following below Num,SeqNo,Ln,Qty 101, 1 , 1, 1 101, 1 , 2, 1 101, 1 , 3, 1 101, 1 , 4, 1 101, 1 , 5, 1 Based on Qty value records will be incremented.If qty value is 4 then o/p will be like below Num,SeqNo,Ln,Qty 101, 1 , 1, 1 101, 1 , 2, 1 101, 1 , 3, 1 101, 1 , 4, 1 Please help on this. Thanks in advance.

akhilesh.shivhare

 Profile Answers by akhilesh.shivhare Questions by akhilesh.shivhare

• Sep 13th, 2013

Yours i/p data

Num,SeqNum,Ln,Qty
101,1,1,5


and o/p data

Num,SeqNum,Ln,Qty
101,1,1,1
101,1,2,1
101,1,3,1
101,1,4,1
101,1,5,1

steps-

- use transformer
-define stage variable stgvar_Qty with value 1 means stgvar_Qty=1
-define loop with condition @ITERATION

Answer Question  Select Best Answer