The Field Combiner stage combines fields coming from the previous stage in a dataflow to create an XML string.
Field Combiner Options
Option Name | Description |
---|---|
Output column name | Specify the name of the column that will have the combined fields as XML string. |
Output Fields | This section helps you select the fields to be combined and perform various actions on
those fields. Note: The Apply Namespace dropdown list and
Element, Attribute, and
Remove buttons get enabled when you select one or more
elements/attributes in the schema pane.
|
XPath | Click anywhere in this field to view the XML path (XPath) of the node highlighted in
the schema pane. To see all the previous XPaths viewed by you, click the down arrow at the
right end of the field. Note: XPath is a language for finding information in an XML
document. For further details on this, see https://www.w3schools.com/xml/xml_xpath.asp
|
- Runtime: Use this button to specify multiple runtime instances of Field Combiner. This results in significant performance improvement.
- OK: Click this button to save all the details entered in this stage.
- Cancel: Click this button to cancel all the updates you made.
- Help: Click this button to refer to the help file for this stage.
Defining Namespace
Namespaces allow you to have duplicate element and attribute names in your output by assigning each element or attribute to an XML namespace.
To define one or more namespaces:
- On the Field Combiner Options screen, click the Namespace button. The Namespace Details pop-up window is displayed.
- In the Prefix column, enter the prefix to be associated with an element or attribute.
- In the Namespace column, specify the URL of the namespace.
- Repeat to define as many namespaces as you want to use.