I am trying to combine summary data from org tables. Data for each year
is stored in a separate org file, with a table for each month. I have
created a file called combined.org, which INCLUDES the org files for
each of the 12 months.
Can't find remote table "october2012".
examplea.org:
* November.
#+tblname: november2013
|------------------+----------+-----------|
| Date | Distance | Heading 3 |
|------------------+----------+-----------|
| [2012-11-03 Sat] | 42.70 | |
| [2012-11-04 Sun] | 31.97 | |
| Total | 74.67 | |
|------------------+----------+-----------|
exampleb.org:
* November.
#+tblname: november2013
|------------------+----------+-----------|
| Date | Distance | Heading 3 |
|------------------+----------+-----------|
| [2012-11-03 Sat] | 42.70 | |
| [2012-11-04 Sun] | 31.97 | |
| Total | 74.67 | |
|------------------+----------+-----------|
combined.org:
#+INCLUDE: "./examplea.org"
#+INCLUDE: "./exampleb.org"
* Monthly Totals.
#+tblname: monthly_total_mileage
|-------+----------|
| Month | Distance |
|-------+----------|
| Oct | |
| Nov | |
|-------+----------|
| Total | |
| | |
|-------+----------|
#+TBLFM: @2$2 = remote(october2012,@2$2)::@3$2 = remote(november2013,@3$2)::
Ian.