Search code examples
talend

Talend Transpose the input text to excel

Hi guys i have the input file in .txt and i want the output in excel format <br/> Input 

m1;01;8.8;02
m2;02;8.7;03
m3;03;8.8;04
m4;04;8.5;05
m5;05;8.4;01

output

m1  m2  m3  m4  m5
8.8 8.7 8.6 8.5 8.4

i used tDenormalize to transpose but the output is not exactly as i want
the output kinda looks like

m1 m2 m3 m4 m5 <br/>

so, someone please help me to get the output and i'm new to talend

Solution

  • OK I got the answer and it's very simple
    So, i want to separate text from special characters in my case its semicolon.. what i did is i just used the tFileInputDelimited to take my input text file then in the component i used field separator as ";" and in the tmap i mapped the first and third column for my output and used tDenormalize to transpose the output
    So, if anyone find this useful it be glad to share for me