HI ALL ,
MY SOURCE DATA IS
EMPID,LOC,PHONE,COUNTRY
1,Home,1234,IND
2,Home,0345,IND
3,Work,0234,JAP
4,Work,1357,USA
1,Work,0012,IND
4,Home,5678,USA
I NEED AN OUT PUT SOME THING LIKE
EMPID,HOME_PHONE,WORK_PHONE,COUNTRY
1,1234,0012,IND
2,0345,NULL,IND
3,NULL,0234,JAP
ANY SUGGESTIONS PLEASE???
RE PIVOTING
Moderators: chulett, rschirm, roy
RE PIVOTING
D.N .MURTHY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My biggest suggestion? Tell us your thoughts. Tell us what you've tried. Right now it just looks like you're coming here cap in hand looking for someone to hand you a solution on a silver platter, as they say.
You could also have saved alot of thrashing in that other thread by putting together (and posting) a complete specification for your situation. Spelling out your requirements in 'tool agnostic' words helps put everything in perspective and gets all the cards on the table. Over in that other thread, people are having to guess what you are trying to do and the data you're dealing with.
Frustrating.
You could also have saved alot of thrashing in that other thread by putting together (and posting) a complete specification for your situation. Spelling out your requirements in 'tool agnostic' words helps put everything in perspective and gets all the cards on the table. Over in that other thread, people are having to guess what you are trying to do and the data you're dealing with.
Frustrating.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
hi thanks for resond you.
actually i completed my job design, i have an solution with me.let me to share you how i solved.
i captured the records which id's having home phone numbers and work phone numberes seperately afterwards i captured which id's does not have home or work phone numbers then i inserted a null vlues for these records .finally i combined all the records.
but it seems not good,its very complicated job design. can any body suggest me any simple way to design a job for this requirement
actually i completed my job design, i have an solution with me.let me to share you how i solved.
i captured the records which id's having home phone numbers and work phone numberes seperately afterwards i captured which id's does not have home or work phone numbers then i inserted a null vlues for these records .finally i combined all the records.
but it seems not good,its very complicated job design. can any body suggest me any simple way to design a job for this requirement
D.N .MURTHY