By adding custom columns can be selected, which rows will be imported. We will use following XML structure for this example: Code Block |
---|
<employees>
<employee>
<element type="name">Jan</element>
<element type="surname">Novak</element>
<element type="birthDate">1.1.1977</element>
<element type="salary" length="10">15.000</element>
</employee>
</employees>
|
As row tag should be selected --employee (this tag repeats for each record).
Now, there need to be added new columns, columns are divided by its type (name, surname, birthday, salary). - Select element [type, length] tag
- Add expression for each column
Info |
---|
Custom columns need to be defined by XPath definition. |
Expression | Result |
---|
[1] | Jan | [1].text() | Jan | [@type="name"] | Jan | [@type="name"].text() | Jan | [2] | Novak | [3] | 1.1.1977 | [@type="salary"] | 15.000 | [@type="salary"].text() | 15.000 | [@type="salary"]/length | 10 |
Info |
---|
Column preview is displayed in section 1. Select the row tag |
Click Continue to proceed to Import settings. Next Steps |