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.
Genius may have its limitations, but stupidity is not thus handicapped.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- 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