RE PIVOTING

dr.murthy · Post by **dr.murthy** » Tue Jan 06, 2009 12:58 am

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???

ray.wurlod · Post by **ray.wurlod** » Tue Jan 06, 2009 1:45 am

Yes, don't keep asking the same question over and over.

We're trying to get to the right answer in your other thread.

dr.murthy · Post by **dr.murthy** » Tue Jan 06, 2009 2:11 am

ray.wurlod wrote:Yes, don't keep asking the same question over and over.

We're trying to get to the right answer in your other thread. ...

Sorry ray

chulett · Post by **chulett** » Tue Jan 06, 2009 9:05 am

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.

dr.murthy · Post by **dr.murthy** » Tue Jan 06, 2009 9:44 am

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