We have a scenario like this given below
NAME LOCATION
balu Hyd
balu chennai
balu banglore
we want output like this in target table
NAME LOCATION
balu hyd/chennai/bangalore
_________________[/i]
Interview Question
Moderators: chulett, rschirm, roy
-
AmeyJoshi14
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
You will get the answer in the below link:
viewtopic.php?t=117541&highlight=Interview
Why are you posting same question in new post??
viewtopic.php?t=117541&highlight=Interview
Why are you posting same question in new post??
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could do worse than understanding what it is that needs to be done, in this case a "vertical pivot". Were you to Search DSXchange for that term, you might even get answers!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.