XML Join

Description

XML Join inserts XML tags from a source stream into a target XML document at a location specified by an XPath expression. Use this step when you need to build or enrich an XML document by merging content from multiple rows into a single XML structure — for example, adding line items to an order document or assembling a report from multiple data sources. The target stream must contain exactly one row representing the base XML document, while the source stream can contain many rows whose tags are all added to the target. The step outputs a single row with the combined XML result.

Configurations

Field Name	Description
Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Target Stream Properties:
Target XML Step	Specify the step that sends the target document to the join
Target XML Field	Specify the field that contains the XML structure
Source Stream Properties:
Source XML Step	Specify the step that send the XML structure(s) to the join that need to be added to the target
Source XML Field	Specify the field that contains the XML structures that get added to the target
Join Condition Properties:
XPath Statement	Specify the XPath statement to find the node in the target document where the tags will be added. When complex join is enabled a single? is used as a placeholder.
Complex Join?	Enable the complex join syntax, using the placeholder in the XPath Statement
Join Comparision Field	Specify Field that contains the values that get replaced in the XPath Statement
Result Stream Properties:
Result XML field	Specify the field that will contain the result.
Encoding	Choose the encoding to be used in the XML Header and to transform the XML.
Omit XML header	Enable checkbox to omit XML header.
Omit null values from XML result	Check Omit null values from XML result to omit the null values from result stream. For example, if empty XML elements (for example, ) that result from null values will be completely removed from the final XML output.