Hi all,

in our current survey we have several tables where we collect information e.g. on trees, deadwood, regeneration. From time to time our field crews enter a new line into this tables but recognized later that the line was not needed. Thus, in our collect desktop we find a lot of plots with empty lines.

I would now like to use the data cleansing methods to identify and delete those empty lines. I was successful in identifying the lines using a query e.g.: idm:blank(trees_dbh) and idm:blank(trees_height) ... . But under the data cleansing step I find only the following cleansing types i) delete record (which would only delete one record in the row) and ii) delete entity (which deletes the entire plot), and update. Also, in the data manager I cannot find an option to delete lines from a table.

Thus, my questions is: How can I delete rows from a table either in the data manger or in data cleansing ?

Greetings from Göttingen Paul

asked 03 Apr '18, 16:03

pmagdon's gravatar image

accept rate: 0%

Hi Paul,
In the Data Manager you can delete a row by just right clicking on a field in the row and selecting "Delete row".
In the Data Cleansing you can delete an entity but this must be selected in your query.
What did you select in your query? The plot? Try to select the tree instead...
Many thanks,
Open Foris Team

permanent link

answered 03 Apr '18, 16:07

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 03 Apr '18, 16:03

question was seen: 450 times

last updated: 03 Apr '18, 16:07