Need Output in Single Row...

praburaj · Post by **praburaj** » Tue Apr 12, 2011 12:18 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Apr 12, 2011 12:42 am

This is a vertical pivot. Search DSXchange for many posts on how to achieve.