From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: Question regarding remote references in tables
Date: Wed, 16 Nov 2011 10:52:21 -0500
Message-ID: <31114.1321458741@alphaville.dokosmarshall.org>
References: <20111116152719.GA7227@client195-107.wlan.hu-berlin.de>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:45512)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQhmk-0005B6-4y
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:52:32 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQhmj-0008DU-0k
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:52:26 -0500
Received: from g6t0187.atlanta.hp.com ([15.193.32.64]:17116)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQhmi-0008D8-Rl
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:52:24 -0500
Received: from g5t0030.atlanta.hp.com (g5t0030.atlanta.hp.com [16.228.8.142])
	by g6t0187.atlanta.hp.com (Postfix) with ESMTP id 212F62842D
	for <emacs-orgmode@gnu.org>; Wed, 16 Nov 2011 15:52:23 +0000 (UTC)
In-Reply-To: Message from Viktor Rosenfeld <listuser36@googlemail.com> of "Wed,
	16 Nov 2011 16:27:19 +0100."
	<20111116152719.GA7227@client195-107.wlan.hu-berlin.de>
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
Cc: nicholas.dokos@hp.com

Viktor Rosenfeld <listuser36@googlemail.com> wrote:

> Hi,
> 
> I'm trying to copy the values of a column in one table to another table
> in. If I understand the manual correctly, this should be possible with
> remote references. But I can't get it to work. In the example below, if
> I evaluate the table formula, column 2 of table "bar" is copied into
> column 3.
> 
> Cheers,
> Viktor
> 
> * Source table
> 
> #+TBLNAME: foo
> | Query | Time |
> |-------+------|
> |     1 |  123 |
> |     2 |  234 |
> |     3 |  345 |
> 
> * Reference table
> 
> #+TBLNAME: bar
> | Query | Garbage | Old Time |
> |-------+---------+----------|
> |     1 | a       |          |
> |     2 | b       |          |
> |     3 | c       |          |
> #+TBLFM: $3=remote(foo,$2)
> 

The manual says:

     $3 = remote(FOO, @@#$2)      copy column 2 from table FOO into
                                  column 3 of the current table

and that works.

Nick

> * Expected
> 
> | Query | Garbage | Old Time |
> |-------+---------+----------|
> |     1 | a       |      123 |
> |     2 | b       |      234 |
> |     3 | c       |      345 |
> 
> * Produced
> 
> | Query | Garbage | Old Time |
> |-------+---------+----------|
> |     1 | a       | a        |
> |     2 | b       | b        |
> |     3 | c       | c        |
>