Re: [join rows]
>>> "JD" == Jude DaShiell writes: > paste is a unix command outside of emacs used to concatenate files > horizontally as opposed to vertically as cat does. Ok, but I was thinking of a lot of tables in one file, so that solution looks complicated, while terry's lisp solution will do that smime.p7s Description: S/MIME cryptographic signature
Re: [join rows]
paste is a unix command outside of emacs used to concatenate files horizontally as opposed to vertically as cat does. On Mon, 8 Jun 2020, Uwe Brauer wrote: > Date: Mon, 8 Jun 2020 07:09:21 > From: Uwe Brauer > To: emacs-orgmode@gnu.org > Subject: Re: [join rows] > > >>> "JD" == Jude DaShiell writes: > >> If what's wanted here is a horizontal join of tables paste(1) might be > > I am not sure what paste(1) means here. Could you please explain? > >> used to start the process however the #TBLFMT: line for the new table >> would need new formulas and column headers may need adjusting. >> Something like this was possible in dBase III+ using modify structure if >> memory serves. > --
Re: [join rows]
On Mon, Jun 08, 2020 at 01:09:21PM +0200, Uwe Brauer wrote: > >>> "JD" == Jude DaShiell writes: > >> If what's wanted here is a horizontal join of tables paste(1) might be > > I am not sure what paste(1) means here. Could you please explain? Paste is a classical UNIX command to "join" (not really in the SQL sense, just by sequence number) files consisting of lines. The "(1)" is the customary way of hinting at the man section (1, aka "Executable programs and shell commands") where the doc is to be found. Just do "man paste" in a shell. Cheers -- t signature.asc Description: Digital signature
Re: [join rows]
>>> "JD" == Jude DaShiell writes: > If what's wanted here is a horizontal join of tables paste(1) might be I am not sure what paste(1) means here. Could you please explain? > used to start the process however the #TBLFMT: line for the new table > would need new formulas and column headers may need adjusting. > Something like this was possible in dBase III+ using modify structure if > memory serves. smime.p7s Description: S/MIME cryptographic signature
Re: [join rows]
> Le 07/06/2020 à 17:09, Uwe Brauer a écrit : > I'm not aware of anything specific for this purpose. A starting point could be the `append' lisp function: > #+begin_src elisp :var table1=RK :var table2=SVD :colnames t > (append table1 table2) > #+end_src Thanks works like charm! smime.p7s Description: S/MIME cryptographic signature
Re: [join rows] (was: join tables from different files)
If what's wanted here is a horizontal join of tables paste(1) might be used to start the process however the #TBLFMT: line for the new table would need new formulas and column headers may need adjusting. Something like this was possible in dBase III+ using modify structure if memory serves. On Mon, 8 Jun 2020, tbanelwebmin wrote: > Date: Mon, 8 Jun 2020 02:18:45 > From: tbanelwebmin > To: emacs-orgmode@gnu.org > Subject: Re: [join rows] (was: join tables from different files) > > Le 07/06/2020 ? 17:09, Uwe Brauer a ?crit?: > > > "t" == tbanelwebmin writes: > > > > Yes you can. > > Use an org-id > > > > Thanks! Nice! > > > > > > I have a another question in this context: > > can I join, say 4 tables, but row wise? > > Say I have > > > > #+TBLNAME: RK > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1 | Q2 | Q3 | total | > > |-+++-+---| > > | RK | 1 | 1 | 0.5 | 2.5 | > > #+TBLFM: $5=$2+$3+$4 > > > > #+TBLNAME: SVD > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1: | Q2 | Q3 | total | > > |-+-+++---| > > | SVD | 0.5 | 1 | 1 | 2.5 | > > #+TBLFM: $5=$2+$3+$4;f1 > > > > #+TBLNAME: MIN > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1 | Q2 | total | > > |-++-+---| > > | MIN | 2 | 0.5 | 2.5 | > > #+TBLFM: $4=$2+$3 > > > > #+TBLNAME: BDF > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1 | Q2 | total | > > |-+--+--+---| > > | MIN | 0.75 | 1.75 | 2.5 | > > #+TBLFM: $4=$2+$3 > > > > Since they don't have the same amount of columns, I'd like to join the 4 > > tables like this > > #+TBLNAME: Total1 > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1 | Q2 | Q3 | total | > > |-+-++-+---| > > | RK | 1 | 1 | 0.5 | 2.5 | > > |-+-++-+---| > > | SVD | 0.5 | 1 | 1 | 2.5 | > > #+TBLFM: $5=$2+$3+$4;f1 > > > > #+TBLNAME: Total2 > > #+ATTR_HTML: :border 2 :rules all :frame border > > | met | Q1 | Q2 | total | > > |-+--+--+---| > > | MIN |2 | 0.5 | 2.5 | > > |-+--+--+---| > > | MIN | 0.75 | 1.75 | 2.5 | > > #+TBLFM: $4=$2+$3 > > > > Is this possible? > > > > regards > > Uwe Brauer > > I'm not aware of anything specific for this purpose. A starting point could > be the `append' lisp function: > > #+begin_src elisp :var table1=RK :var table2=SVD :colnames t > (append table1 table2) > #+end_src > > #+RESULTS: > | met | Q1: | Q2 | Q3 | total | > |-+-++-+---| > | RK | 1 | 1 | 0.5 | 2.5 | > | SVD | 0.5 | 1 | 1 | 2.5 | > > > > --
Re: [join rows] (was: join tables from different files)
Le 07/06/2020 à 17:09, Uwe Brauer a écrit : > "t" == tbanelwebmin writes: > > Yes you can. > Use an org-id > > Thanks! Nice! > > > I have a another question in this context: > can I join, say 4 tables, but row wise? > Say I have > > #+TBLNAME: RK > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1 | Q2 | Q3 | total | > |-+++-+---| > | RK | 1 | 1 | 0.5 | 2.5 | > #+TBLFM: $5=$2+$3+$4 > > #+TBLNAME: SVD > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1: | Q2 | Q3 | total | > |-+-+++---| > | SVD | 0.5 | 1 | 1 | 2.5 | > #+TBLFM: $5=$2+$3+$4;f1 > > #+TBLNAME: MIN > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1 | Q2 | total | > |-++-+---| > | MIN | 2 | 0.5 | 2.5 | > #+TBLFM: $4=$2+$3 > > #+TBLNAME: BDF > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1 | Q2 | total | > |-+--+--+---| > | MIN | 0.75 | 1.75 | 2.5 | > #+TBLFM: $4=$2+$3 > > Since they don't have the same amount of columns, I'd like to join the 4 > tables like this > #+TBLNAME: Total1 > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1 | Q2 | Q3 | total | > |-+-++-+---| > | RK | 1 | 1 | 0.5 | 2.5 | > |-+-++-+---| > | SVD | 0.5 | 1 | 1 | 2.5 | > #+TBLFM: $5=$2+$3+$4;f1 > > #+TBLNAME: Total2 > #+ATTR_HTML: :border 2 :rules all :frame border > | met | Q1 | Q2 | total | > |-+--+--+---| > | MIN |2 | 0.5 | 2.5 | > |-+--+--+---| > | MIN | 0.75 | 1.75 | 2.5 | > #+TBLFM: $4=$2+$3 > > Is this possible? > > regards > Uwe Brauer I'm not aware of anything specific for this purpose. A starting point could be the `append' lisp function: #+begin_src elisp :var table1=RK :var table2=SVD :colnames t (append table1 table2) #+end_src #+RESULTS: | met | Q1: | Q2 | Q3 | total | |-+-++-+---| | RK | 1 | 1 | 0.5 | 2.5 | | SVD | 0.5 | 1 | 1 | 2.5 |