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

I have data in Table as ID 1 2 3 1 4 3 3 5 6 6 7 Now I want to have Output as repeatating records in one table & non-repeatating in another table Table 1 : Id 2 4 5 7 Table 2: ID 1 1 3 3 3 6 6 Thanks, Sushil

anirudh

• May 9th, 2017

You can use sort->aggregrator->count_rows->transformer stage write constraints row_count>1 to one file and row_count>1 to another output file

Neha

• Apr 7th, 2017

Seq File-> Aggregator (Count group by ID)->Transformer(Two output link , Use @Iteration1 and put @Iteration value in OpLnk2

Answer Question  Select Best Answer