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