Re: Question regarding remote references in tables

[Nick Dokos <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        |
>