DSXchange

Hi,
how to do reverse pivot

source:
EID,1stname,Middlename.Lastname
101,sunil,kumar,sharma
102,web,sphere,datastage

my output will be like this:

EID,Name
101,sunil
102,web
101,kumar
102,sphere
101,sharma
102,datastage

please how to this one

I am not sure, but Check the column import stage / pivot stage.

DS User

Search DSXchange for "vertical pivot" in server jobs. There are at least three ways, all of which have been published here.