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
Single row to multiple rows with multiply
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Mon Feb 07, 2011 1:17 am
- Location: madhu
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
You may start here here and you might come up with a simpler approach.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
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.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 5
- Joined: Mon Feb 07, 2011 1:17 am
- Location: madhu
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI