How to refer to remote table, in another file, as a source block variable?

How to refer to remote table, in another file, as a source block variable?

[William Denton]

I can't figure this one out.  Let's say I have a table in an Org file, like so:

# -----

* Primes

#+NAME: test_table
| number | prime |
|--------+-------|
| two    | yes   |
| three  | yes   |
| four   | no    |

# -----

In another file, I want to bring this table into a source block as a variable. 
If it was the same file, I'd say ":var t=test_table" and that's that.  But 
what's the syntax for a different file?  I can't figure it out from the docs [1] 
and none of my attempts with quotes, file:, etc. work.  It's something like 
this, isn't it?  But what?

#+begin_src R :var t=(remote(table.org::*Primes))
t
#+end_src

Thanks,

Bill

[1] https://orgmode.org/manual/References.html#References
--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
Caveat lector.                      ---   STAPLR: https://staplr.org/

Re: How to refer to remote table, in another file, as a source block variable?

[William Denton]

My apologies for sending this around a second time, but I still haven't got it
so I thought I'd try again.  If it's possible to refer to a remote table in 
another file, I've love to know how.


Bill


On 7 August 2020, William Denton wrote:

> I can't figure this one out.  Let's say I have a table in an Org file, like 
> so:
>
> # -----
>
> * Primes
>
> #+NAME: test_table
> | number | prime |
> |--------+-------|
> | two    | yes   |
> | three  | yes   |
> | four   | no    |
>
> # -----
>
> In another file, I want to bring this table into a source block as a 
> variable. If it was the same file, I'd say ":var t=test_table" and that's 
> that.  But what's the syntax for a different file?  I can't figure it out 
> from the docs [1] and none of my attempts with quotes, file:, etc. work. 
> It's something like this, isn't it?  But what?
>
> #+begin_src R :var t=(remote(table.org::*Primes))
> t
> #+end_src
>
> Thanks,
>
> Bill
>
> [1] https://orgmode.org/manual/References.html#References
> --
> William Denton :: Toronto, Canada   ---   Listening to Art: 
> https://listeningtoart.org/
> https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
> Caveat lector.                      ---   STAPLR: https://staplr.org/
>

--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
Caveat lector.                      ---   STAPLR: https://staplr.org/

Re: How to refer to remote table, in another file, as a source block variable?

[John Kitchin]

[-- Attachment #1: Type: text/plain, Size: 2161 bytes --]

I think you are looking for (Assuming your table is in an org file called
test.org):

#+BEGIN_SRC ipython :var data=test.org:test_table
for row in data:
    print(row)
#+END_SRC

#+RESULTS:
:results:
# Out [2]:
# output
['two', 'yes']
['three', 'yes']
['four', 'no']

:end:
John

-----------------------------------
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu



On Mon, Sep 14, 2020 at 5:58 PM William Denton <wtd@pobox.com> wrote:

> My apologies for sending this around a second time, but I still haven't
> got it
> so I thought I'd try again.  If it's possible to refer to a remote table
> in
> another file, I've love to know how.
>
>
> Bill
>
>
> On 7 August 2020, William Denton wrote:
>
> > I can't figure this one out.  Let's say I have a table in an Org file,
> like
> > so:
> >
> > # -----
> >
> > * Primes
> >
> > #+NAME: test_table
> > | number | prime |
> > |--------+-------|
> > | two    | yes   |
> > | three  | yes   |
> > | four   | no    |
> >
> > # -----
> >
> > In another file, I want to bring this table into a source block as a
> > variable. If it was the same file, I'd say ":var t=test_table" and
> that's
> > that.  But what's the syntax for a different file?  I can't figure it
> out
> > from the docs [1] and none of my attempts with quotes, file:, etc. work.
> > It's something like this, isn't it?  But what?
> >
> > #+begin_src R :var t=(remote(table.org::*Primes))
> > t
> > #+end_src
> >
> > Thanks,
> >
> > Bill
> >
> > [1] https://orgmode.org/manual/References.html#References
> > --
> > William Denton :: Toronto, Canada   ---   Listening to Art:
> > https://listeningtoart.org/
> > https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
> > Caveat lector.                      ---   STAPLR: https://staplr.org/
> >
>
> --
> William Denton :: Toronto, Canada   ---   Listening to Art:
> https://listeningtoart.org/
> https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
> Caveat lector.                      ---   STAPLR: https://staplr.org/
>
>

[-- Attachment #2: Type: text/html, Size: 3905 bytes --]

Re: How to refer to remote table, in another file, as a source block variable?

[William Denton]

Aha!  Thank you!  I'll try to do a patch for the docs so this is clearer there.

Bill

On 14 September 2020, John Kitchin wrote:

> I think you are looking for (Assuming your table is in an org file called
> test.org):
>
> #+BEGIN_SRC ipython :var data=test.org:test_table
> for row in data:
>    print(row)
> #+END_SRC
>
> #+RESULTS:
> :results:
> # Out [2]:
> # output
> ['two', 'yes']
> ['three', 'yes']
> ['four', 'no']

--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
Caveat lector.                      ---   STAPLR: https://staplr.org/

Re: How to refer to remote table, in another file, as a source block variable?

[Bastien]

Hi William,

William Denton <wtd@pobox.com> writes:

> I'll try to do a patch for the docs so this is clearer there.

TIA!

-- 
 Bastien