Re: Columns to rows in q

Community Support
1

Not sure whether this is going to help but just some idea here:

exec (raze side,'side)!(raze price,'size) by sym:sym from t

2

that is the idea basically
see http://code.kx.com/wiki/Pivot for more details on pivoting

Cheers,

  Attila

3

q)select (price!size) by sym:sym from tab

sym size                                                    
AAPL 438 438.01 438.03 438.82 439 439.1!100 200 500 20 200 100

can someone tell me how to pick one key value pair at a time and add them as cols to the tab .