Skip to main content

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 NameDescription
1Step nameSpecify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Content Tab:
1EncodingSpecify the encoding to use. This encoding is specified in the header of the XML file
2Output ValueSpecify the name of the new field that contains the XML
3Root XML elementSpecify the name of the root element in the generated element.
4Omit XML headerEnable to not include the XML header in the output.
5Omit null values from the XML resultDo 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:
1FieldnameSpecify the name of the field
2Element nameSpecify the name of the element in the XML file to use
3TypeSpecify the Type of the field can be either String, Date, or Number
4FormatSpecify the Format mask with which to convert data; see Number Formats for a complete description of format specifiers
5LengthOutput string is padded to this length if it is specified
6PrecisionSpecify the precision.
7CurrencySpecify the Symbol used to represent currencies like $10,000.00 or E5.000,00
8DecimalSpecify the decimal separator. The Decimal point separator can be a "." (10,000.00) or "," (5.000,00)
9GroupingSpecify a thousand’s group separator. A group separator can be a "," (10,000.00) or "." (5.000,00)
10NullSpecify the string to use in case the field value is null.
11AttributeChoose Y/N from the dropdown list. Choose Y to make this an attribute (N means: element)
12Attribute parent nameYou 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.