Page 1 of 1

Need Output in Single Row...

Posted: Tue Apr 12, 2011 12:18 am
by praburaj
Hi,

My Source is a File and My data's are like I mentioned below.

Column1 Column2

101 James
101 204
101 US

I need my output like this

EmpId Name Zipcod Location
101 James 204 US.

Multiple records value I need it in single records. How to do that?

Please help me to get rid of this Issue....

Posted: Tue Apr 12, 2011 12:42 am
by ray.wurlod
This is a vertical pivot. Search DSXchange for many posts on how to achieve.