7.8.12.5. Algorithms in tabular form

Formulas can also be displayed in table form. This makes editing long and/or complicated algorithms much faster.

You have the option of creating a completely new algorithm (either in the Characteristics table [Algorithm-Table] or Characteristics algorithm [Attribute algorithm] window) or editing the existing one.

Call up the table of characteristics [Algorithm-Table] by clicking on the Table button.

[Tip]Tip

For very large tables, you can use the filter function directly under the heading to restrict the view.

Edit feature algorithm

Edit feature algorithm

Example (lines marked in red in the figure above)

If ENTL equals 4 and SWITCH equals 3 and SWITCH2 equals 10, then IDENTL equals E2.

Restrictions

  • The algorithm contains only one IF/ELSEIF/ELSE block. IF is mandatory.

  • Each IF or ELSEIF only uses AND or OR for the entire condition. A mixture of OR and AND is not permitted!

  • The conditions use EQ (equal), NEQ (unequal), LT (less), LE (less equal), GT (greater), GE (greater equal) and have one side as a variable and the other as a constant value.

  • EQ and NEQ allow multiple values for the same variable.

  • LT, LE, GT, GE are either used for a single value or as a pair for an upper/lower limit.

  • The assigned value is a constant number or a constant string or a single variable (subforms are currently not supported)

If the algorithm cannot be parsed, a message appears instead of the dialog.

Edit table

You have various options for editing the table. Basically, you can double-click in each cell to edit it. In addition, some functions from the table module are available to you:

  • line up Move [Move row up]: Moves the row up by one.

  • line down Move [Move row down]: Moves the row down by one.

  • variable Add [Add variable]: Adds a new column.

  • line Add [Add row]: Adds a new row.

  • Delete line [Delete row]: Deletes a row from the table.

  • Tables Import [Table import]: Add a CSV file to the spreadsheet.

    The CSV file can use either a semicolon or a comma as a separator.

  • Tables Export [Table export]: Exports the table as a CSV file.