Hello,
#+NAME: A
Table with header row here
#+NAME: B
Table with header row here
#+TBLFML: $1 = remote(A,$1)
Does nothing.
$1 = remote(A,@0) referring current row w implicit column does not work. Debug shows on row 2 of current table it returns the value of row 1, the header, on table A.
Same result as above with @0$1 instead.
$1 = remote(A,@2$1) does what expected. For every row copies the same value of @2$1 from table A to table B.
Need to refer multiple columns on different tables in a column formula for a final table.
Please advise. Thanks.