XML Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Querying Mixed Content

An XML element has mixed content when it contains a value and it contains child elements. You can create an XPath query predicate to filter element values that are divided by child elements. However, the Integration Service does not evaluate predicates that occur after the first child element in mixed content.

For example, an XML file might contain a NAME element with mixed content:

<NAME>
  Kathy 
    <MIDDLE> Mary </MIDDLE>
  Russell 
</NAME>

Element NAME has the value “Kathy”, a child element “MIDDLE”, and a second value “Russell.” The NAME column value is “KathyRussell.” However, the Integration Service evaluates the NAME “Kathy.”

The following query is false: