Linda, Thanks for sharing. I included the table header for clarity. I will drop it prior to executing. Henry's solution is ideal since my table can have 2-N columns
Joe On Fri, Mar 18, 2016 at 2:19 AM, Linda A Alvord <[email protected]> wrote: > 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
