Map and Table Calculation

Predefined variable %K

Variable to calculate with the class names or IDs of the domain of a table.

Syntax

%K

Notes:

• K stands for Key column.
• The table is supposed to use a Class, ID, group or Bool domain.
• Normally, column calculations are performed on all records of specified column names. To calculate with specific records of a table using a Class, ID, group or Bool domain, specify [%K] as an index behind the output column name in an expression. %K can be replaced by a class name, ID, etc. in double quotes.

  Column[expr]	to use values of a column indexed by record values, class names or IDs
  Table.Column[expr]	to use values of a column in another table, indexed by record values, class names or IDs
  Table.Ext.Column[expr]	to use values of a column in a table with another extension than .tbt (e.g. .his), indexed by record values, class names or IDs.

  In between the square brackets, you can write an expression expr containing %K.

Tip:

When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

TabCalc

Examples

TabCalc example:

OutCol1 = %K

OutCol2 = NAME(%K)

OutCol3 = CODE(%K)

OutCol4 = IFF(%K="Vacant",0,Population)

OutCol5{dom=value;vr=0:1000:1}:=?

OutCol5["Vacant"]:=0

OutCol5["Residential"]:=500

• Column OutCol1 contains the names of the domain, that is used by the table. The column uses the same domain as the table.
• Column OutCol2 contains the names of the items in the domain of the table; the column uses the system String domain.
• Column OutCol3 contains the codes of the items in the domain of the table; the column uses the system String domain.
• Column OutCol4 contains value 0 if the record is "Vacant" else it contains the values of column Population.
• Column OutCol5 is created as an editable column. The Residential record of this column is assigned value 500; the Vacant record is assigned value 0.

TabCalc example using two different tables:

Suppose we have a table Province that contains information about the amount of products available in provinces. Further, we have a table ProductPrice with product prices. To obtain the yield of wood per province, multiply column Wood in table Landuse with the cell containing the wood price in column Price of table ProductPrice.

WoodPrice = ProductPrice.Price["Wood"] * Province.Wood

Note:

When using data from different tables all table names have to be fully specified in the TabCalc expression.

See also: