Copying information from one table to another in Arena OF (Select distinct)

  • Asked
  • Active
  • Viewed 1331 times
0

Hello everyone,

I have a need in Arena OF, which I don't think is currently possible, but I'd like to ask if anyone has a good idea.

We want to use Arena OF to collect data from a shrubland inventory in California for carbon estimation.

The field methodology we are considering is line intercept transects. For each one-meter section, we will collect cover and height (in four classes) by species. So, we will have a table with Transect_ID, Section_ID, Species, Cover, and HeightClass.

At the end of the transect, we want to individually measure a "typical" individual of each species and height class in each transect.

Ideally, using the transect table, I would do a SELECT DISTINCT and create new records in a new table of individuals.

Any ideas?

Thank you so much as always!!

Oscar

1

Accepted answer

Dear Oscar,
At the moment we don't have such a feature in Arena.
What you could do is just create a new entity with an attribute "species" as key, and a validation rule that checks if that species has been inserted in the items of the previous entity (called "section" for example), with an expression like this:
count(section[section_species == this]) > 0
Please let us know if you need further assistance from our side.
Many thanks,
Open Foris Team

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.