Linking columns ColumnsConcatenate
When importing, it links the columns using a separator.
In general:
<string>stop;column name;delimiter;stop;column name</string>
Example:
Input data header:
id | city | postal code | street | descriptive_number |
Syntax:
<ColumnsConcatenate>
<string>stop1;address;;dynamic;ulice</string>
<string>stop1;address; ;dynamic;cislo_popisne</string>
<string>stop1;address;, ;dynamic;psc</string>
<string>stop1;address; ;dynamic;mesto</string>
</ColumnsConcatenate>
In the ColumnsConcatenate section on the first line, the empty column track1 address is linked to the column dynamic ulice.(without the separator, the separator would only create a gap in front of the street)
On the next line is linked column address already filled with street with descriptive number using the space separator. And similarly, postal code and city are added.
Note:
If we are creating an address from multiple fields, it is necessary to add a command to the importer to create an address field so that the combined data can be stored somewhere.
In <ColumnsAdd> you need to have the correct formatting. Only the track type and column name are filled in. The preset value is not filled in.
<ColumnsAdd>
<string>0;address;</string>
</ColumnsAdd>
The empty preset value is filled according to <ColumnsConcatenate>