Increment Values based on column (Looping)

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.

Ram_1104
Profile Answers by Ram_1104 Questions by Ram_1104
Sep 3rd, 2013
3
11560

Questions by Ram_1104

DataStage

Answer

Showing Answers 1 - 3 of 3 Answers

akhilesh.shivhare
Profile Answers 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<=INPUTLINK.Qty
as per urs example @ITERATION<=5

- column in derivation

INPUTLINK.Num - Num
INPUTLINK.SeqNum - SeqNum
@ITERATION - Ln
stgvar_Qty - Qty

there is no need to define stgvar_Qty also , use direct value 1 for column Qty