Hi, I tried to get more results for Plot level, as number of species in each plot. There this line

regenSpecies <- sqldf( "SELECT plot_id_ , regen_species_code AS species_code FROM regen " );

caused an error, and I checked in RStudio that regen$regen_species_code was not read in dbGetQuery clause.

I could solve this by adding a "fake" line into previous "Regen - Count total" module as: test <- regen$regen_species_code

BUT, it so that only those fields are read in which are written into the code under that particular entity?

Cheers, Lauri

asked 20 Jan '15, 03:24

LauriV's gravatar image

LauriV
3162212
accept rate: 22%


Dear Lauri,

If you want to have variables read for a specific entity (e.g. regen), you need to add that variable in a calculation step that uses that entity (as you did in the regen – count total).

Afterwards that variable can be used in another calculation step.

I think you can also add a simple comment that includes the variable. e.g.: # regen_ species_ count

in the regen – count total calculation step.

Mino

permanent link

answered 20 Jan '15, 14:23

Mino%20Togna's gravatar image

Mino Togna ♦♦
4365
accept rate: 10%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×61

question asked: 20 Jan '15, 03:24

question was seen: 2,134 times

last updated: 20 Jan '15, 14:23