From: Uwe Brauer <oub@mat.ucm.es>
To: emacs-orgmode@gnu.org
Subject: [join rows] (was: join tables from different files)
Date: Sun, 07 Jun 2020 17:09:59 +0200 [thread overview]
Message-ID: <87lfkync8o.fsf_-_@mat.ucm.es> (raw)
In-Reply-To: dcb93108-67f8-df93-46b9-1ca54fe8f90d@free.fr
[-- Attachment #1.1.1: Type: text/plain, Size: 1661 bytes --]
>>> "t" == tbanelwebmin <tbanelwebmin@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
#+begin_src
#+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
#+end_src
Since they don't have the same amount of columns, I'd like to join the 4 tables like this
#+begin_src
#+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
#+end_src
Is this possible?
regards
Uwe Brauer
[-- Attachment #1.1.2: Type: text/html, Size: 2418 bytes --]
[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]
next prev parent reply other threads:[~2020-06-07 15:10 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2020-06-06 20:40 join tables from different files Uwe Brauer
2020-06-07 6:33 ` tbanelwebmin
2020-06-07 15:09 ` Uwe Brauer [this message]
2020-06-08 6:18 ` [join rows] (was: join tables from different files) tbanelwebmin
2020-06-08 9:41 ` Jude DaShiell
2020-06-08 11:09 ` [join rows] Uwe Brauer
2020-06-08 11:30 ` tomas
2020-06-08 13:55 ` Jude DaShiell
2020-06-08 18:37 ` Uwe Brauer
2020-06-08 11:08 ` Uwe Brauer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87lfkync8o.fsf_-_@mat.ucm.es \
--to=oub@mat.ucm.es \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).