outstanding! thank you
On Thu, Mar 17, 2016 at 10:54 PM, Henry Rich <[email protected]> wrote:
> 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
>>>
>>
>> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
