From mboxrd@z Thu Jan  1 00:00:00 1970
From: Ian Barton <lists@wilkesley.net>
Subject: Remote References to Tables in Included Files.
Date: Thu, 12 Dec 2013 14:32:52 +0000
Message-ID: <52A9C914.6080901@wilkesley.net>
Reply-To: ian@manor-farm.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:49850)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1Vr7K6-0005lx-4n
	for emacs-orgmode@gnu.org; Thu, 12 Dec 2013 09:33:12 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1Vr7K0-00027f-17
	for emacs-orgmode@gnu.org; Thu, 12 Dec 2013 09:33:06 -0500
Received: from mail2.wilkesley.net ([109.74.196.44]:43117
	helo=li40-130.members.linode.com)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1Vr7Jz-00027A-Qj
	for emacs-orgmode@gnu.org; Thu, 12 Dec 2013 09:32:59 -0500
Received: from scamper2.bantercat.co.uk (unknown [46.33.134.31])
	(Authenticated sender: lists@wilkesley.net)
	by li40-130.members.linode.com (Postfix) with ESMTPSA id B0DE9F618A
	for <emacs-orgmode@gnu.org>; Thu, 12 Dec 2013 14:32:56 +0000 (UTC)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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.