Need some idea

ajithaselvan · Post by **ajithaselvan** » Mon Nov 14, 2011 4:39 am

Hi all,

Can anyone help me how to implement?
my input is like

col1 col2
a a1
a a2
a a3
b b1
b b2

I need to split the values in col2 as separate columns based on col1.
ie., if same group of col1 has diff vales in col2, then col2 values will be splited as separate columns

Output:
out_col1, out_col2, out_col3,out_col4
a , a1 , a2 , a3
b ,b1 ,b2, null

Regards,

chulett · Post by **chulett** » Mon Nov 14, 2011 7:55 am

That would be what is called a "vertical pivot", also known as rows to columns. So... pivot stage.

venkatvelpula · Post by **venkatvelpula** » Mon Nov 14, 2011 9:34 am

I think, Pivot stage can be used as long as you have same number of records for each key column group.