FOR / DO Looping in transformer

agpt · Post by **agpt** » Tue May 25, 2010 10:31 am

How do we implement FOR or DO looping in transformer?

priyadarshikunal · Post by **priyadarshikunal** » Tue May 25, 2010 10:55 am

First let IBM release the next version of datastage

and then you will be able to use looping variables. Till then use workarounds including parallel routines.

agpt · Post by **agpt** » Tue May 25, 2010 11:03 am

Thats what exactly I am looking for.... with which work around I can implement it

chulett · Post by **chulett** » Tue May 25, 2010 12:04 pm

How about you first explain to us why you think you need to do "looping" in a transformer? Perhaps there is another way to accomplish whatever it is that you need to do.

agpt · Post by **agpt** » Wed May 26, 2010 12:02 am

I have data like:

ID Flag
1 Y
1 N
1 Y
2 Y
2 Y
2 N
2 N
3 N
3 Y

The output I want is:

ID Flag
1 Y
2 Y
3 Y

That is across each id it would check for flag and if this is 'Y' against any occurence, It would give Y a final output with one occurence of ID.

truenorth · Post by **truenorth** » Wed May 26, 2010 12:11 am

If I interpret your logic correctly that you want one occurrence of Y's, then use the constraint Flag = 'Y' in Transformer together with either a Sort (no dups) or Dedupe.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed May 26, 2010 2:17 am

Or aggregate by ID and Max(flag)

ray.wurlod · Post by **ray.wurlod** » Wed May 26, 2010 4:06 am

Or stage variable to detect whether 'Y' has been encountered, and either stage variables or Key Change column from Sort stage to detect change of key.

chulett · Post by **chulett** » Wed May 26, 2010 6:17 am

Trivial in a Server job as well. No looping required.

agpt · Post by **agpt** » Wed May 26, 2010 10:18 am

hmm
Thanks to all.