clionton

How to do this logic in JasperETL. Any help appriciated :) Input: P#$D1$D2$D3$D4$D6$D7$DT$DS$DZ$M1$M2$S1$S2$S3$S4$B1$B2$B3$B4 9555552$1$$$$$$$T$$$C$K$100$200$300$$3$43$53$ Output should be like this P#$D0$M0$B0 9555552$1$C$100$3 9555552$1$C$100$43 9555552$1$C$100$53 9555552$1$C$200$3 9555552$1$C$200$43 9555552$1$C$200$53 9555552$1$C$300$3 9555552$1$C$300$43 9555552$1$C$300$53 9555552$1$K$100$3 9555552$1$K$100$43 9555552$1$K$100$53 9555552$1$K$200$3 9555552$1$K$200$43 9555552$1$K$200$53 9555552$1$K$300$3 9555552$1$K$300$43 9555552$1$K$300$53 9555552$T$C$100$3 9555552$T$C$100$43 9555552$T$C$100$53 9555552$T$C$200$3 9555552$T$C$200$43 9555552$T$C$200$53 9555552$T$C$300$3 9555552$T$C$300$43 9555552$T$C$300$53 9555552$T$K$100$3 9555552$T$K$100$43 9555552$T$K$100$53 9555552$T$K$200$3 9555552$T$K$200$43 9555552$T$K$200$53 9555552$T$K$300$3 9555552$T$K$300$43 9555552$T$K$300$53 Any idea is ok (tMap,tNormalize, tJava, tJavaFlex...or any sql) Thanks in advance :)

Solution by Shong (Thanks very much Shong) http://www.talendforge.org/forum/viewtopic.php?pid=13118#p13118

Any help or idea would be appricated. Thanks in advance :)

Hi Everyone!!! I have a data as below how do i do this with JasperETL (tmap/tnormalize) in data col1 col2 col3 col4 col5 col6 a 2 3 4 b 3 1 c 1 2 4 7 output should be like this. col1 Acol a 2 a 3 a 4 b 3 b 1 c 1 c 2 c 4 c 7 Thanks in advance :)