Concatenation

To concatenate fields from the external database into one field in the Plant SCADA database, add separate entries to the [ImportFilterMap] section. Each section needs to contain the name of a relevant external column and the name of the destination column in Plant SCADA. The entries needs to appear in the order in which the fields are to be concatenated.

So, if the external data source has a field called "IOdev" containing the value "M", and another field called "IOaddr" containing the value "61", and you want to join them together so that the value "M61" is imported into the Plant SCADA "Addr" field, this is how it would be done:

[ImportFilterMap]
Addr1= IOdev -> Addr
Addr2= IOaddr -> Addr

Here, you need to verify that there are no sections in the format file called [Addr1] or [Addr2], unless you need some filtering or conversion.

See Also

Field Conversion