Pivot stage

mayura · Post by **mayura** » Wed Apr 28, 2010 3:05 am

Can anyone give me example how pivot stage works...

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 4:31 am

Yes, and so can the manual (pivot.pdf).

elias.shaik · Post by **elias.shaik** » Wed Apr 28, 2010 9:22 am

lets say we have a table with columns a,b,c,d and you would like to pivot the data on column a ,(b&c&d) then you would have 3 records for every one source record (assuming all columns have values at source).

source:
a b c d

target:

a b
a c
a d

--
Elias

mayura · Post by **mayura** » Wed Apr 28, 2010 11:05 pm

ray.wurlod wrote:Yes, and so can the manual (pivot.pdf). ...

yeah !!

thx