Viktor Rosenfeld <listuse...@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 | >