Sub-element field

The Sub-element field allows a second level of element identification in the XML Import Configuration window.

How this field works

In some cases you may need to identify information to import via a sub-element within the main Element.

For example, the XML may contain an Author element with a Name sub-element and also a Publisher element with a Name sub-element. This two-level identification can be used to distinguish the first Name element from the second Name element.

<record>
<author>
<name>Joe Bloggs</name>
<birthdate>01/01/1976</birthdate>
</author>
<publisher>
<name>SunSpice Publishing</name>
<location>Auckland, New Zealand</location>
</publisher>
</record>

Field details

Field type

Text field

Internal field name

SUB_ELEMENT

Location

XML Import Configuration window > Field Mapping tab

Searching on this field

Use a Select Statement.

Reporting on this field

This is how to select this field in Reporting.

  • Field (Across the page) reports: Select Sub-Element.

  • Group (Down the page) reports: Expand Fields then select Sub-Element.

You can sort on this field.