Module Table Calculator
The table calculator calculates a new attribute from existing attributes based on a mathematical formula. Attributes are addressed by the character 'f' (for 'field') followed by the field number (i.e.: f1, f2, ..., fn) or by the field name in square brackets (e.g.: [Field Name]).
Examples:
sin(f1) * f2 + f3
[Population] / [Area]
The following operators are available for the formula definition:
+ Addition
- Subtraction
* Multiplication
/ Division
^ power
abs(x) - absolute value
sqrt(x) - square root
ln(x) - natural logarithm
log(x) - base 10 logarithm
exp(x) - exponential
sin(x) - sine
cos(x) - cosine
tan(x) - tangent
asin(x) - arcsine
acos(x) - arccosine
atan(x) - arctangent
atan2(x, y) - arctangent of x/y
gt(x, y) - if x>y the result is 1.0, else 0.0
lt(x, y) - if x<y the result is 1.0, else 0.0
eq(x, y) - if x=y the result is 1.0, else 0.0
mod(x, y) - returns the floating point remainder of x/y
ifelse(c, x, y) - if c=1 the result is x, else y
int(x) - integer part of floating point value x
pi() - returns the value of Pi
- Author: V.Olaya (c) 2004, O.Conrad (c) 2011
- Specification: grid
- Menu: Table|Calculus
Parameters
| Name | Type | Identifier | Description | Constraints |
Input | Table | Table (input) | TABLE | - | - |
Output | Result (*) | Table (optional output) | RESULT | - | - |
Options | Formula | Text | FORMULA | - | Default: f1 + f2 |
Field Name | Text | NAME | - | Default: Calculation |
Field (*) | Table field | FIELD | - | - |
(*) optional |
Command-line
Usage: saga_cmd table_calculus 1 [-FORMULA <str>] [-NAME <str>] -TABLE <str> [-RESULT <str>] [-FIELD <str>]
-FORMULA:<str> Formula
Text
Default: f1 + f2
-NAME:<str> Field Name
Text
Default: Calculation
-TABLE:<str> Table
Table (input)
-RESULT:<str> Result
Table (optional output)
-FIELD:<str> Field
Table field