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
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