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 <tbanelweb...@free.fr> > 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 <tbanelweb...@free.fr> 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 | > > > > --
