Sigmafine 4 Format for Transfer Data (With Control Table)

The control table is an AF table that defines the processing sequence of data columns in the data file and maps the columns to Transfer attributes. It also provides the user with the flexibility to set default missing values, override fields with a specific value, and mark specific fields that can be combined to form a unique “key.” These keys can then be used to ignore duplicate transfers during the import operation. This AF table must exist in the same database where the transfers are stored. An example of a control table is shown below.

Example Control Table

Keyword	SourceColumn	Default	Force	Unique	Formula
Source	1			False
Destination	2			False
Name	3			False
StartTime	4		\<ST>	False
EndTime	5		\<ET>	False
MeasuredMass	6	0		False

The fields of the control table are described in the following table.

Control Table Field Definitions

Keyword	Usage Note
Keyword	Name of the transfer record Attribute or property for the transfers.
SourceColumn	Column number from the input data file that contains the data for the specified keyword field. Columns numbers start with 0 as the first column.
Default	Value used for this field if the incoming data is missing for this column. Otherwise, this field is left blank.
Force	Value used to override the incoming data. The entry can be a value or one of the following strings:\<B> = Force this column to blank.\<ST> = Force the current start time for this column.\<ET> = Force the current end time for this column.
Unique	TRUE = Use this column to create a unique “key” for the transfer. The Data Loader does not import transfers with duplicate keys. Leave the field blank otherwise.
Formula	Use this field for a formula in the form Operand1;Operator;Operand2, that must evaluate to TRUE before the Data Loader processes the current line of the data file. For more details about formulas, see section "Sigmafine 4 Control Table Formulas."