[Jprogramming] transform table columns to rows

[Henry Rich]

Your table is regular, so

,/@:(({. ,. }.)"1)

would also work.

Henry Rich

On 3/17/2016 10:47 PM, Henry Rich wrote:
> ;@:(<@({. ,. }.)"1)
>
> Untested.
>
> Henry Rich
>
> On 3/17/2016 10:44 PM, Joe Bogner wrote:
>> Is there a simple or efficient transform of
>>
>> tbl =: ' ' cut every LF cut (0 : 0)
>> id col1 col2 col3 col4 col5 col6
>> 1 ab cd ef gh hi jk
>> 2 lm no pq rs tu vw
>> 3 xy zz aa bb cc dd
>> )
>>
>> +--+----+----+----+----+----+----+
>>
>> |id|col1|col2|col3|col4|col5|col6|
>>
>> +--+----+----+----+----+----+----+
>>
>> |1 |ab |cd |ef |gh |hi |jk |
>>
>> +--+----+----+----+----+----+----+
>>
>> |2 |lm |no |pq |rs |tu |vw |
>>
>> +--+----+----+----+----+----+----+
>>
>> |3 |xy |zz |aa |bb |cc |dd |
>>
>> +--+----+----+----+----+----+----+
>>
>>
>>
>> to
>>
>>
>> ('1';'ab'),('1';'cd'),('1';'ef'),('1';'gh'),('1';'hi'),('1';'jk'),:('2';'lm')
>>
>>
>> +-+--+
>>
>> |1|ab|
>>
>> +-+--+
>>
>> |1|cd|
>>
>> +-+--+
>>
>> |1|ef|
>>
>> +-+--+
>>
>> |1|gh|
>>
>> +-+--+
>>
>> |1|hi|
>>
>> +-+--+
>>
>> |1|jk|
>>
>> +-+--+
>>
>> |2|lm|
>>
>> +-+--+
>>
>>     ...
>>
>>
>>
>> In other words, take the first column and duplicate the other columns as
>> rows
>>
>>
>> thanks in advance
>> ----------------------------------------------------------------------
>> For information about J forums see http://www.jsoftware.com/forums.htm
>