Linking columns ColumnsConcatenate

Z Solvertech
Skočit na navigaci Skočit na vyhledávání
Jiné jazyky:

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>