The Data Processor transformation accepts a subset of XPath statements in the Output field when the Mode field set to is
Add
or
Match or Add
. When you select these mode settings, the Data Processor transformation creates elements as needed to match the XPath expression in the Output field.
You can use a simple XPath expression in the Output field. A simple expression has child axes, parent axes, or variables. Simple expressions do not have predicates, functions or complex axes. For example, you can use the following Output field expressions:
person/data
/root/ceo/name
$var/name
person/../ceo
You can use a simple predicate with cardinality for an element with several instances. For example, you can use the following Output field expression:
person/phone[4]
You can use a simple predicate with a formula with an equal sign, with simple XPaths on the left-hand side of the equal sign. For example, you can use the following Output field expressions:
Person[id=10]
Person[id=$id]
Person[id=@dp:input()/ID]
Company[name=upper-case($compName)]
Person[role="manager" and id=1]
You can also use a combination of a simple expression with cardinality and a formula that uses a simple XPath on the left-hand side of the equal sign. For example, you can use the following Output field expressions:
company[4]/details[id=$myid]/phone
When the Mode field is set to
Match
, the Output field can also accept complex XPath expressions.