Hi,Following a post on the wiki, I am able to pivot a table on a givencolumn, but I am struggling to reverse the operation.In the example below, I pivot the table "t" on column "x". I thenattempt to take the resulting table, "t2", and unpivot it, but I end uplosing column "x". Is there an elegant solution?q)t: ([]x: raze 4#' til 3; y: raze 3# enlist `a`b`c`d; z: 12?1f)q)tx y z --------------0 a 0.5074456 0 b 0.3056222 0 c 0.6886731 0 d 0.2316704 1 a 0.5876646 1 b 0.3976699 1 c 0.3982375 1 d 0.1628311 2 a 0.7589342 2 b 0.8416255 2 c 0.047553262 d 0.217142 q)t2: exec (distinct t`y)#y!z by x:x from tq)t2x| a b c d -| ----------------------------------------0| 0.5074456 0.3056222 0.6886731 0.23167041| 0.5876646 0.3976699 0.3982375 0.16283112| 0.7589342 0.8416255 0.04755326 0.217142 q)raze {([] y:key x; z:value x)} each t2y z ------------a 0.5074456 b 0.3056222 c 0.6886731 d 0.2316704 a 0.5876646 b 0.3976699 c 0.3982375 d 0.1628311 a 0.7589342 b 0.8416255 c 0.04755326d 0.217142 Thanks,Leon
