Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Anonymous
Not applicable

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