Hi Pawel, I would also check out Roger Hui's great essay on Inverted Tables. https://code.jsoftware.com/wiki/Essays/Inverted_Table
I use his verbs ifa and afi often. ifa =: <@(>"1)@|: NB. inverted from atoms afi =: |:@:(<"_1@>) NB. atoms from inverted On Tue, Aug 23, 2022 at 1:03 PM Pawel Jakubas <jakubas.pa...@gmail.com> wrote: > Thanks for the answers. > And how would you can go from > > ┌──────┬──────────┬────────┐ > │deptno│dname │location│ > ├──────┼──────────┼────────┤ > │10 │Accounting│New York│ > │20 │Research │Dallas │ > │30 │Sales │Chicago │ > │40 │Operations│Boston │ > └──────┴──────────┴────────┘ > > to > > ┌──────┬──────────┬──────────┐ > │deptno│dname │location │ > ├──────┼──────────┼──────────┤ > │10 │Accounting│"New York"│ > ├──────┼──────────┼──────────┤ > │20 │Research │Dallas │ > ├──────┼──────────┼──────────┤ > │30 │Sales │Chicago │ > ├──────┼──────────┼──────────┤ > │40 │Operations│Boston │ > └──────┴──────────┴──────────┘ > > ? So the other way around. > > Thanks in advance and cheers, > > Pawel > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- *Kenneth Lettow* Director Market Intelligence | Thomas, a Xometry Company Thomasnet.com <https://www.thomasnet.com> | #TogetherForIndustry <https://www.thomasnet.com> <https://www.thomasnet.com> <https://www.thomasnet.com>[image: Thomas For Industry] <https://www.thomasnet.com> ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
