Help on Transformer Looping

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rakesh.puli
Premium Member
Premium Member
Posts: 29
Joined: Wed Mar 22, 2017 10:45 pm

Help on Transformer Looping

Post by rakesh.puli »

Hi

I have a requirement as below, I have to achieve the output like the below.
how I can do this with the @iteration variable in transformer and what derivation i have to give in the stage variable and looping variable.Please help me with this

Input record

123

Output

123
123
123
123
123

Thanks
Rakesh
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

That does not make any sense. Have you tried experimenting?
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As noted... what?

Put your requirement into words, perhaps even the same words the requirement was given to you with. And if you are going to post an example, use real data rather than some made up junk that doesn't help your cause one bit. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
rakesh.puli
Premium Member
Premium Member
Posts: 29
Joined: Wed Mar 22, 2017 10:45 pm

Post by rakesh.puli »

Hi Chulett/qt_ky

I tried using the looping variable @looping <=5 in transformer stage and assigned the input record to this looping variable and I got the ouput as below. thank you all for your inputs

Code: Select all

123
123
123
123
123
thanks
Rakesh
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

And... resolved?
-craig

"You can never have too many knives" -- Logan Nine Fingers
rakesh.puli
Premium Member
Premium Member
Posts: 29
Joined: Wed Mar 22, 2017 10:45 pm

Post by rakesh.puli »

Yes.
Post Reply