Building on the inverted table defns
dfftbl=: {. ,: ifa@}.
tblfdf=: {. , afi@{:
tblfdf dfftbl B
┌──┬──────┬──────────┬─────────┐
│Id│Name │Job │Status │
├──┼──────┼──────────┼─────────┤
│3 │Jerry │Unemployed│Married │
├──┼──────┼──────────┼─────────┤
│6 │Jan │CEO │Married │
├──┼──────┼──────────┼─────────┤
│5 │Frieda│student │Single │
├──┼──────┼──────────┼─────────┤
│1 │Alex │Waiter │Separated│
└──┴──────┴──────────┴─────────┘
On Wed, 24 Aug 2022, 06:45 'Kenneth Lettow' via Programming, <
[email protected]> wrote:
> 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 <[email protected]>
> 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
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
