When defining the import mapping, as an alternative to using individual source table columns dragged from the Source pane of the Import Link window, you can also link together several values in the Target pane, in the Source Name column and use them as a single source. For example, the source used for the drawing name is dwg + equip which is a combination of the drawing ID and equipment ID (the '+' character is entered automatically if you select both sources by dragging them to the same data field).
The source can be composed of several different functions using the arithmetic operators (+, -, /, *) in addition to the string operators. The following conventions apply:
-
Arithmetic operators are treated as such only in data fields whose table column type is number.
-
Each arithmetic operator is preceded by the '!' character, for example:
param1 !+ param2 !- param3
(If the values are: param1 = 2, param2 = 10, and param3 = 5, the result of the above formula will be 7.)
-
Constants must be enclosed within single quotes, for example:
param1!+ '2' !* '5'
(Because the operations are performed from left to right, if the value of param1 is 2, the result of the above formula will be 20.)
In the following example, the fluid temperatures are calculated using the base temperatures in the following formulas:
-
Normal temperature = Base temperature + 10
-
Minimum temperature = (Base temperature + 10) / 1.2
-
Maximum temperature = (Base temperature + 10) * 1.2
The syntax used by the Source Name data field is entered as follows:
