Help with tmap

[clionton]

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

[oliviert]

It won't help, but I'm trying to do exactly the same

 

It seems to me that tnormalize should be the object to use, but I'm puzzled about how to actually use it...

;) :blink:

[clionton]

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

[clionton]

Solution by Shong (Thanks very much Shong)

 

http://www.talendforge.org/forum/viewtopic.php?pid=13118#p13118