need the output as of below in the datastage parallel job
Moderators: chulett, rschirm, roy
need the output as of below in the datastage parallel job
i/p
------
cola colb colc cold
a 1 xx 12.50
a 2 xx 13.59
a 2 xx 14.50
a 2 yy 15.20
b 1 xx 13.20
b 2 xx 12.00
b 3 xx 13.00
b 3 zz 14.00
o/p
------
cola colc 1 2 3
a xx 12.50 28.09 0.00
a yy 0.00 15.20 0.00
b xx 13.20 12.00 13.00
b zz 0.00 0.00 14.00
------
cola colb colc cold
a 1 xx 12.50
a 2 xx 13.59
a 2 xx 14.50
a 2 yy 15.20
b 1 xx 13.20
b 2 xx 12.00
b 3 xx 13.00
b 3 zz 14.00
o/p
------
cola colc 1 2 3
a xx 12.50 28.09 0.00
a yy 0.00 15.20 0.00
b xx 13.20 12.00 13.00
b zz 0.00 0.00 14.00
BVIKRAM
Sorry but you can't just drop made up input and output examples on us and then expect a fully fleshed out answer when next you stop by.
Describe your requirements in words then let us know what you've tried and what specific questions you have. And real sample data is always a good idea. Then we'd be willing - and able - to help.
High level - it's a vertical pivot of rows to columns.
Describe your requirements in words then let us know what you've tried and what specific questions you have. And real sample data is always a good idea. Then we'd be willing - and able - to help.
High level - it's a vertical pivot of rows to columns.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: need the output as of below in the datastage parallel jo
1)First do group by on cola,colb,colc and sum on cold
2)Now split your flow into three streams based on your colb(1,2,3 based) by using transformer or filter stage.
3) Now try to join them back based on keys cola and colc only
do not use colb in join
Do full outer join on that.
whichever output values you see nulls in columns 1,2,3 convert them to 0.00
Just do little tweaking here and there. You should be able to achieve it.
2)Now split your flow into three streams based on your colb(1,2,3 based) by using transformer or filter stage.
3) Now try to join them back based on keys cola and colc only
do not use colb in join
Do full outer join on that.
whichever output values you see nulls in columns 1,2,3 convert them to 0.00
Just do little tweaking here and there. You should be able to achieve it.
Yes thats right!
This morning when i read the post, it looks like an SMS to the mate \ team member , not the request to get the solution.
Its not a good practice and i was waiting for the comments .
I totally agree.
This morning when i read the post, it looks like an SMS to the mate \ team member , not the request to get the solution.
Its not a good practice and i was waiting for the comments .
I totally agree.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Appreciate that, it will make it much easier to help you out in the future and get you to a solution faster if you help set things up for us properly.
Now, make sure to come back and clarify your requirements and ask some actual questions if you need more help than what puliram has supplied so far!
Now, make sure to come back and clarify your requirements and ask some actual questions if you need more help than what puliram has supplied so far!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: need the output as of below in the datastage parallel jo
Thanks puliram!
Today i will try as per your suggestions and will let you know the results
Today i will try as per your suggestions and will let you know the results
BVIKRAM
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: