topic Re: tJavaRow, iterate on column in Talend Studio

tJavaRow, iterate on column

Anonymous — Fri, 06 Nov 2015 15:06:30 GMT

Hi !
I have a lot of files with a large number of column and i'd like to know if it's possible using a tJavaRow to iterate over the column (for each row) ?
Let's say I have :
date value1 value2 value3 ... valueN

and in output i'd like to have :
date value1
date value2
...
date valueN
Under condition to get the column ?

Thanks !

Re: tJavaRow, iterate on column

Anonymous — Tue, 10 Nov 2015 14:40:31 GMT

Hi
I don't understand you said that 'Under condition to get the column', it seems you need to normalize the rows, take a look at the tNormalize component, let me know if it fits your need?

BRS
Shong

Re: tJavaRow, iterate on column

Anonymous — Fri, 13 Nov 2015 14:05:55 GMT

In fact I have a lot of column and for example :
Id col2 jan__12 ,fev__12 .... col 14 col15 ... col20 jan__13 ... dec__13
i just want to keep the column that are jan .. to dec but they are in différent places and not in the row.
How can I iterate over the column in my tJavaRow and try if the header contains(jan ... to dec) and get the value.
Then I have to tunpivot to have something like :
-id , jan__12, value
-id, jan__12, value
...
-id dec__17 value
etc...
Thanks