Single row to multiple rows with multiply

[Madhusudhan]

DS version : 8.0.1
AIX

I have below requirement. Please give me suggestion.

Source :

col 1 | count | multiplier

a|4|10
b|2|20


I want output like this.

a|1|10
a|2|20
a|3|30
a|4|40
b|1|20
b|2|40

Thanks in advance

[priyadarshikunal]

You may start here here and you might come up with a simpler approach.

[chulett]

Another suggestion? Upgrade. Your solutions are being limited by the age of your version. Transformer looping (introduced in 8.5 from what I recall) would give you a better solution.

[ArndW]

This would be simpler if you had DataStage 8.7 or higher, which support loops within a transform stage.
If your multiplier (4 and 2 in your example) is a small number and the highest number known, you could make one output per possible value all going to a funnel stage.
If your multiplier can have more values than are comfortably programmed into a transform stage, then the solution isn't quite as easy or straightforward and you could follow some of the recommendations in the thread linked to above.

[priyadarshikunal]

This would be simpler if you had DataStage 8.7 or higher, which support loops within a transform stage.

Small correction. 8.5 or higher

[Madhusudhan]

Am at client Location.

Upgrade not posmsible. Please give another solution.

[priyadarshikunal]

Solution other than upgrade is posted in my first post.

[chulett]

Which is also why I noted that it is another solution.