Add XML
Description
Add XML column is a step in the Transform Plugin for Process Studio Workflows. The Add XML column step encodes the content of a number of fields in a row in XML. This XML is added to the row in the form of a String field.
Configurations
No. | Field Name | Description |
---|---|---|
1 | Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
Content Tab: | ||
1 | Encoding | Specify the encoding to use. This encoding is specified in the header of the XML file |
2 | Output Value | Specify the name of the new field that contains the XML |
3 | Root XML element | Specify the name of the root element in the generated element. |
4 | Omit XML header | Enable to not include the XML header in the output. |
5 | Omit null values from the XML result | Do not add or eliminate elements or attributes with null values. This is often used to limit the size of the target XML. |
Fields Tab: | The Fields tab is where you configure the output fields and their formats. The table below describes each of the available properties for a field: | |
1 | Fieldname | Specify the name of the field |
2 | Element name | Specify the name of the element in the XML file to use |
3 | Type | Specify the Type of the field can be either String, Date, or Number |
4 | Format | Specify the Format mask with which to convert data; see Number Formats for a complete description of format specifiers |
5 | Length | Output string is padded to this length if it is specified |
6 | Precision | Specify the precision. |
7 | Currency | Specify the Symbol used to represent currencies like $10,000.00 or E5.000,00 |
8 | Decimal | Specify the decimal separator. The Decimal point separator can be a "." (10,000.00) or "," (5.000,00) |
9 | Grouping | Specify a thousand’s group separator. A group separator can be a "," (10,000.00) or "." (5.000,00) |
10 | Null | Specify the string to use in case the field value is null. |
11 | Attribute | Choose Y/N from the dropdown list. Choose Y to make this an attribute (N means: element) |
12 | Attribute parent name | You can specify the name of the parent element to add the attribute to if previous parameter attribute is set to Y. If no parent name is specified, the attribute is set in the parent element. |