Add Pivot function to GEL

[GoogleCodeExporter]

GEL could perhaps use a new pivot function. Something like pivot[rowIndex%VAR] 
(rowIndex modulo VARIABLE) that would split into multiple columns a single 
column, multi-value rowed file based on the row.index sequence that would need 
to be split such as rows 1-3, or rows 1-5 recurring etc.  Currently, I was able 
to accomplish some of the functionality by using Jython expression of 'return 
rowIndex%2' to facet even and odd rows and then export and copy-paste combine 
externally in MS Excel, then re-import into gw. More beneficial would be to 
expand upon the UI for Edit Column/Split into Several Columns.  Whereby a 3rd 
option would use the new pivot function to map rows to columns. Essentially a 
lazy pivot function.

Original issue reported on code.google.com by thadguidry on 22 Jun 2010 at 7:17

[GoogleCodeExporter]

Example file of data to be split into columns is attached.  Sometimes the use 
case will include more than 2 rows of "TYPES" to be split into columns, but in 
this example file it's just 2 rows each.

Original comment by thadguidry on 22 Jun 2010 at 7:30

Attachments:

• Split_Me_by_Pivot.txt

[GoogleCodeExporter]

Original comment by dfhu...@gmail.com on 18 Jul 2010 at 1:12

• Changed state: Accepted
• Added labels: Milestone-1.6

[GoogleCodeExporter]

Fixed by r1133.

Original comment by dfhu...@google.com on 8 Aug 2010 at 6:31

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by tfmorris on 18 Sep 2012 at 2:58

• Added labels: Milestone-2.0
• Removed labels: Milestone-1.6