Reverse Pivoting

jbkishore · Post by **jbkishore** » Wed Mar 28, 2012 1:37 am

[b]Hi,
there are three columns empid, salmonth, sal contains the values 101,jan,1000
101 feb 1000
like twelve rows are there then my required out put is like
contains 13 columns empid jan feb march.......dec and the values are
101 1000 1000 1000 like this.

Thank you.. [/b]

nani0907 · Post by **nani0907** » Wed Mar 28, 2012 2:01 am

you need to write logic using stage variables.

first keep a flag for new and repeated values of emid and slao take counter in another stage var.
in third stage varible based upon the flag of 1 stage varoiable coancate the salmnt &sal.

then sort and rove dups..

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2012 2:03 am

I think you need a new keyboard fairly soon, Nani - your current one seems to be skipping characters.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2012 2:05 am

Welcome aboard.

Search DSXchange for "vertical pivot" (another name for reverse pivot) to learn techniques.