Re: join tables from different files

[tbanelwebmin]

Yes you can.
Use an org-id

Suppose you have a table in file x.org, under some title:

--------- x.org ----------------------
* title

| a  |  b |
|----+----|
| aa |  5 |
| bb |  7 |
| aa | 11 |
--------------------------------------


Add an ID by calling: M-x org-id-get-create. You end up with:

--------- x.org ----------------------
* title
  :PROPERTIES:
  :ID:       c8b8bb22-e42e-426f-afb0-4cb19aed27ad
  :END:

| a  |  b |
|----+----|
| aa |  5 |
| bb |  7 |
| aa | 11 |
--------------------------------------

Globally save the new ID by calling M-: (org-id-locations-save). You will see 
c8b8bb22-e42e-426f-afb0-4cb19aed27ad in the ~/.emacs.d/.org-id-locations file.


In another file, say y.org, you may now reference this remote table with the ID 
in an aggregated, transposed, or joined block:

--------- y.org ----------------------
#+BEGIN: aggregate :table "c8b8bb22-e42e-426f-afb0-4cb19aed27ad" :cols "a 
vsum(b)"
| a  | vsum(b) |
|----+---------|
| aa |      16 |
| bb |       7 |
#+END:
--------------------------------------

The wizard for creating the aggregated (or joined, or transposed) block does 
not (yet) complete remote tables names, only buffer-local ones. The wizard may 
be called with C-c C-x x (or C-x C-x i on older versions of Org Mode).


Note that those global IDs are also used by the spreadsheet remote() function. 
Example:

--------- z.org ----------------------
|  b |
|  5 |
|  7 |
| 11 |
#+TBLFM: $1=remote(c8b8bb22-e42e-426f-afb0-4cb19aed27ad,@@#$2)
--------------------------------------


Have fun
Thierry

Le 06/06/2020 à 22:40, Uwe Brauer a écrit :

> Hi 
>
> I know I can either user 
> (org-insert-dblock:aggregate)
> (org-insert-dblock:join)
>
> To join or aggregate tables with in the same files. 
>
> But can  I join tables from different files?
>
> Thanks
>
> Uwe Brauer 
>
>
>