Pascal. This works for the first situation. How do you rearrange the rows based on the third colum of data? Linda
-----Original Message----- From: Programming [mailto:[email protected]] On Behalf Of 'Pascal Jasmin' via Programming Sent: Sunday, June 26, 2016 9:28 PM To: [email protected] Subject: Re: [Jprogramming] Rearranging rows of tables can also work with "tie break" columns. A bit more natural with 0 based columns: 3 3 $ 2 5 2 2 1 4 5 6 7 2 5 2 2 1 4 5 6 7 0 1 ({"1 /:~ ]) 3 3 $ 2 5 2 2 1 4 5 6 7 2 1 4 2 5 2 5 6 7 ----- Original Message ----- From: Henry Rich <[email protected]> To: [email protected] Sent: Sunday, June 26, 2016 8:59 PM Subject: Re: [Jprogramming] Rearranging rows of tables f =: [ /: {"1~ untested. Henry Rich On 6/26/2016 8:50 PM, Linda A Alvord wrote: > Design a function f, so D f 3 will arrange the rows in order from > small to large values in column 3 andD f 1 will do the same for column 1. > > > > > > A=:(<30),(<'CAT'),<11 > > B=:(<18),(<'GOAT'),<10 > > C=:(<27),(<'BAT'),<9 > > [D=:A,B,:C > > ---T----T--┐ > > │30│CAT │11│ > > +--+----+--+ > > │18│GOAT│10│ > > +--+----+--+ > > │27│BAT │9 │ > > L--+----+--- > > > > If you prefer 3 f D and 1 f D, that's OK. Thanks, Linda > > ---------------------------------------------------------------------- > 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
