transpose column values into row values

[Anonymous]

Hi all,
I'm a newbie,pls help me out to convert
my input
c1                                    c2                                                       c3                                                                           c4
M1,M3,M4,M6    0.685846988,0.919621311,0.99116034,0.338322162  0.536476537,0.304836384,0.624345034,0.045164593 

 0.011237709,0.897359576,0.216382079,0.84172398

 output should be

M1                       M3                      M4                    M6                                           
0.685846988     0.919621311        0.99116034        0.338322162                  
0.536476537     0.304836384        0.624345034       0.045164593                
0.011237709     0.897359576        0.216382079       0.84172398                      
0.906233083     0.439797637         0.055043695      0.26720812                   

I have tried tpivotdelimited,tnormalize,tdenormalize,taggregateroew.Pls help me I don't know where I'm doing wrong..


Any suggestion...Thanks in advance


Thanks 
VK

[Anonymous]

Hi,
Please take a look at TalendHelpCenter:tNormalize component which normalizes the input flow following SQL standard.
[font=noto, Helvetica, Arial, sans-serif]Best regards[/font]
[font=noto, Helvetica, Arial, sans-serif]Sabrina[/font]