;@:(<@({. ,. }.)"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
