To pull different columns from different tables, use
columnlist {"0 2 a
or
columnlist {"_1 a
Henry Rich
Bill Harris wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Henry Rich <[email protected]> writes:
>
>> I don't understand fully (did you mean 'column' instead of 'row' towards
>> the end?), but I'll lead with
>
> Yep, I meant "column."
>
>> 3 2 5 {."0 1 (2) {"1 a
>> 2 7 12 0 0
>> 22 27 0 0 0
>> 42 47 52 57 0
>
> That's really a nice solution; it took me a moment to see it because I
> wasn't expecting it. One advantage is that I can set the element of the
> left argument to 0 for tables I want to ignore; then I can add this to
> another array I create similarly.
>
> That's a bit confusing. The different tables of a have the desired data
> in different columns, as I'm pulling this from different spreadsheets
> done in different years, and the data structure changed at least once
> over the years. So I can pull the first 5, say, from column 3 and add
> that to the next 5 which have the data in column 4.
>
> Thanks!
>
> Bill
> - --
> Bill Harris http://facilitatedsystems.com/weblog/
> Facilitated Systems Everett, WA 98208 USA
> http://facilitatedsystems.com/ phone: +1 425 337-5541
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAkofTsYACgkQ3J3HaQTDvd9y+QCeLF3tWQj2FvvZj+TbEW8ziqlh
> l90An0vp5bSo0fexD9v7wKFySjm8BCTI
> =sNUz
> -----END PGP SIGNATURE-----
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
