f=: 13 :'18 2$,( ,.{."1 }."2 y),"1 0 }."1 }."2 y'
f tblLinda -----Original Message----- From: Programming [mailto:[email protected]] On Behalf Of Linda A Alvord Sent: Friday, March 18, 2016 2:20 AM To: [email protected] Subject: Re: [Jprogramming] transform table columns to rows Henry, Your result has 24 rows. Linda -----Original Message----- From: Programming [mailto:[email protected]] On Behalf Of Henry Rich Sent: Thursday, March 17, 2016 10:55 PM To: Programming forum Subject: Re: [Jprogramming] transform table columns to rows 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
