Use the Content tab to include the following options for the output XML file.
| Option | Description |
|---|---|
| Zipped | Select this option if you want the XML file to be stored in a ZIP archive. |
| Encoding | Specify the file encoding to use. Leave blank to use the default encoding on your system. To use Unicode, specify UTF-8 or UTF-16. On first use, PDI searches your system for available encodings. The encoding specified is noted in the header of the output XML file. |
| Namespace | Specify the default namespace, which is a collection of names that can be used for uniquely named elements and attributes. A runtime check occurs that ensures the URI of the default namespace is a valid URI. A runtime error stops the transformation and logs an error if the URI is invalid. |
| Parent XML element | Select the name of the root element in the XML document. |
| Row XML element | Select the name of the row element to use in the XML document. |
| Split every ... rows | Specify the maximum number of rows of data to generate to a single XML file before another file is created. |
| Omit null values from XML output | Select this option to exclude elements containing null values from the output XML file. Clear this option to include elements containing null values in the output XML file. You can specify another value to replace null with the Null field in the Fields tab. For example, you may have the <data1> and <data2> elements as part of <Rows>, and <data2> contains a null value. If you select Omit null values from XML output, then the <data2> element does not appear in <Rows> in the output XML file, as shown in the following sample output:
<?xml version='1.0' encoding='UTF-8'?> <Rows xmlns="namespace&"> <Row><data1>ABCD</data1> </Row> </Rows> If you clear Omit null values from XML output, then the <data2> element does appear in <Rows> in the output XML file, as shown in the following sample output:
<?xml version='1.0' encoding='UTF-8'?> <Rows xmlns="namespace&"> <Row><data1>ABCD</data1> <data2/></Row> </Rows> |