Generating Alphanumeric sequence using Row Generator

visvacfirvin · Post by **visvacfirvin** » Fri Jul 25, 2008 11:08 am

Is there a way to generate alphanumeric sequence using Row generator? If so what option should i set. I tried the algorithm alphabets, its generating the values by taking each character at a time for a row.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 25, 2008 7:21 pm

Not really. You could use a Cycle to generate a single character alphanumeric field, but beyond that you need multiple stages (Lookups and Transformer).

visvacfirvin · Post by **visvacfirvin** » Fri Jul 25, 2008 7:30 pm

Thanks Ray. Was trying different options in Row Generator for long time. Tht clears my confusion.

visvacfirvin · Post by **visvacfirvin** » Sun Aug 03, 2008 9:24 pm

Ray,
This question is repeatedly asked in interviews. Is there a way we could use functions in row generator to generate alphanumeric sequence?

Thanks,
Firvin

ray.wurlod · Post by **ray.wurlod** » Sun Aug 03, 2008 9:46 pm

No.

There is (currently) no scope for user-defined generator routines in the Row or Column Generator stages.

You could build your own (Build) stage, or you could invoke your own routine from a Transformer stage. That exhausts the possibilities in the current version.

If you would like to see this capability, and particularly if you can estabilsh a business case justifying it, then you can submit an enhancement request either through your support provider or through DSXchange or DeveloperWorks.

visvacfirvin · Post by **visvacfirvin** » Mon Aug 04, 2008 8:08 am

Oh. Thanks Ray!!!