Modify option settings

Settings for the Modify option.

Output type
This option is available if you are modifying a simple field. It specifies whether the dataflow field should be written to an XML element or attribute.
Element
Select this to write the field's data to an XML element. Specify the element name you want to use in the Element name field.
Attribute
Writes the field's data to an attribute of the parent element. Specify the attribute name you want to use in the Attribute name field.
Element name/Attribute name
Specifies the name of the element or attribute to be written to the XML file. The default name is the dataflow field name.
Change all children to
This option is available if you are modifying a complex element. It specifies the type of XML you want the complex element to contain. One of the following:
No change
The child types remain as they are currently defined, either element or attribute. You can specify the type for each field individually by selecting the field and clicking Modify.
Elements
All simple fields under the element are written as XML elements.
Attributes
All simple fields under the element are written as XML attributes.
Namespace
If you want to specify an XML namespace to use for the element or attribute, select it here. You can create namespaces on the Fields tab of the Write to XML stage.
Include empty fields
Check this box to include in the output file XML elements that have a null value or no data. If you do not check this box, empty elements will not be included in the output.

For example, if you define an element named <City> but there is a record that does not have any data in the City field, the XML output will contain the following if you check Include empty fields:

<City xs:nil="true"></City>

If you do not check this box the <City> element will not be written to the output file.