[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Question regarding remote references in tables
From: |
Nick Dokos |
Subject: |
Re: [O] Question regarding remote references in tables |
Date: |
Wed, 16 Nov 2011 10:52:21 -0500 |
Viktor Rosenfeld <address@hidden> 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 |
>