Anonymous
Not applicable
2015-11-13
09:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
268 Views