Sigmafine 4 Format Control Table Formulas
A formula is in the form Operand1;Operator;Operand2;
Control Table Formula Operands
| Operand | Description |
|---|---|
| Operand1 | Operand1 must be the reference to a column in the data file (zero is the first column) proceeded by either a tilde (~) or a number symbol (#). A tilde specifies that the column contains a string value. A number symbol specifies that the column contains a number. |
| Operator | The Operator is the type of comparison to make. It can be equal (=), less than (\<), greater than (>), or not equal (!=). |
| Operand2 | Operand2 can be either a string or number constant or the reference to a column in the data file proceeded by either a tilde (~) or a number symbol (#). If Operand2 is not preceded by a tilde or number symbol, the Data loader evaluates it as a constant value. If Operand1 is a string, then Operand2 must be a string. If Operand1 is a number, then Operand2 must be a number. |
The formula can be read as: If Operand1 is Operator (equal to, less than, greater than, or not equal to) Operand2 then the KEYWORD data column equals the Source field, defaults to the Default field, or is forced to the Force field. It may, or may not, be unique. Consider the following example.
EXAMPLE 1
| Keyword | SourceColumn | Default | Force | Unique | Formula |
|---|---|---|---|---|---|
| Source | 1 | False | ~1;!=,ABC |
The Data Loader processes this line as follows.
- If column 1 in the data file does not equal the string “ABC” then import column 1 as Source.
- If column 1 does equal “ABC” then do nothing.
Note: The column numbers in the data file start with 0, reference to column 1 in this example refers to the second column of the data file.
Use of multiple formula lines for the same keyword is valid. Note the following example.
EXAMPLE 2
| Keyword | SourceColumn | Default | Force | Unique | Formula |
|---|---|---|---|---|---|
| OrigDestination | 0 | S | False | #7;>,0.00 | |
| OrigDestination | 0 | D | False | #7;<,0.00 | |
| OrigDestination | 0 | 5 | False | #7;=0.00 |
The Data Loader processes these lines as follows.
- If column 7 in the data file has a number greater than 0.00, then force the value of S/D to S.
- If column 7 in the data file has a number less than 0.00, then force the value of S/D to D.
- If column 7 in the data file has a number equal to 0.00, then import data file column 6 as value of S/D; or if the data file column 6 is null, set S/D to S.
Note: The column numbers in the data file start with 0, reference to column 7 in this example refers to the eighth column of the data file.