Select by Numerical Expression
- Author: O.Conrad (c) 2013
- Menu: Table | Selection
Description
Selects records for which the expression evaluates to non-zero. The expression syntax is the same as the one for the table calculator. If an attribute field is selected, the expression evaluates only this attribute, which can be addressed with the letter 'x' in the expression formula. If no attribute is selected, attributes are addressed by the character 'f' (for 'field') followed by the field number (i.e.: f1, f2, ..., fn) or by the field in quota (e.g.: "Field Name").
Examples:
- f1 > f2
- eq("Population" * 0.001, "Area")
Parameters
| | Name | Type | Identifier | Description | Constraints |
|---|
| Input | Table | table, input | TABLE | - | - |
| Output | Copy | shapes, output | COPY | - | - |
| Options | Attribute | table field | FIELD | attribute to be searched; if not set all attributes will be searched | - |
| Expression | text | EXPRESSION | - | Default: f1 > 0 |
| Inverse | boolean | INVERSE | - | Default: 0 |
| Use No-Data | boolean | USE_NODATA | - | Default: 0 |
| Method | choice | METHOD | - | Available Choices:
[0] new selection
[1] add to current selection
[2] select from current selection
[3] remove from current selection
Default: 0 |
| Post Job | choice | POSTJOB | - | Available Choices:
[0] none
[1] copy
[2] move
[3] delete
Default: 0 |
Command Line
Usage: saga_cmd table_tools 18 [-TABLE ] [-FIELD ] [-EXPRESSION ] [-INVERSE ] [-USE_NODATA ] [-METHOD ] [-POSTJOB ] [-COPY ]
-TABLE: Table
table, input
-FIELD: Attribute
table field
-EXPRESSION: Expression
text
Default: f1 > 0
-INVERSE: Inverse
boolean
Default: 0
-USE_NODATA: Use No-Data
boolean
Default: 0
-METHOD: Method
choice
Available Choices:
[0] new selection
[1] add to current selection
[2] select from current selection
[3] remove from current selection
Default: 0
-POSTJOB: Post Job
choice
Available Choices:
[0] none
[1] copy
[2] move
[3] delete
Default: 0
-COPY: Copy
shapes, output