Can you make a temporary org-buffer that copies all those tables into one place, and then join them?
Uwe Brauer <o...@mat.ucm.es> writes: > I think I almost have a working workflow. > > What I need is a functionality to join either columns or rows of tables > that are in different files. > > Here is what I have in mind for tables that are in the same file > > > ** Columns > > #+NAME: T1 > | col1 | col2 | > > | 1 | 2 | > > #+NAME: T2 > | col3 | > > | 3 | > > #+BEGIN_SRC emacs-lisp :var t1=T1 t2=T2 > (cl-mapcar #'append t1 t2) > #+END_SRC > > > #+RESULTS: > | col1 | col2 | col3 | > | 1 | 2 | 3 | > > ** Rows > > #+BEGIN_SRC emacs-lisp :var t1=T1 t2=T2 > (append t1 t2) > #+END_SRC > > > #+RESULTS: > | col1 | col2 | > | 1 | 2 | > | col3 | | > | 3 | | > > > > Now the 3rd package orgtbl-aggregate allows me to aggerate column of > tables that are in different files, via an ID generated via > org-id-get-create > and saved via org-id-update-id-locations > as in > > #+BEGIN: aggregate :table "uwe" :cols "Level" > #+END: > > Where the table uwe is located in a different file. However it seems > only to work for one table at the time, so if you have 20 tables in 20 > files that a bit complicated > > Any idea how to append column or rows from different table in different > files in one go? > > Thanks > > Uwe -- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu Pronouns: he/him/his