# Add XML
## Add XML
### Description
The Add XML transform allows you to encode 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.
### Supported Engines
| Hop Engine | ✓ |
| ---------- | ------------ |
| Spark | ? |
| Flink | ? |
| Dataflow | ? |
### Options
#### Content Tab
| Option | Description |
| ------------------------------------ | ----------------------------------------------------------------------------------------------------------- |
| Transform name | Name of the transform. |
| Encoding | The encoding to use; this encoding is specified in the header of the XML file |
| Output Value | The name of the new field that contains the XML |
| Root XML element | The name of the root element in the generated element |
| Omit XML header | Enable to not include the XML header in the output. |
| Omit null values from the XML result | Do not add 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.
| Option | Description |
| --------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Fieldname | Name of the field |
| Element name | The name of the element in the XML file to use |
| Type | Type of the field can be either String, Date, or Number |
| Format | Select the date or number format to apply to the values in the field |
| Length | Output string is padded to this length if it is specified |
| Precision | The number of decimal places used to display floating point numbers. |
| Currency | Symbol used to represent currencies like $10,000.00 or E5.000,00 |
| Decimal | The symbol used to represent the decimal point in floating point numbers, typically "." (10.75) or "," (5,25) |
| Grouping | The symbol used to represent a thousands separator, typically "," (10,000.00) or "." (5.000,00) |
| Null | The string to use in case the field value is null. |
| Attribute | If Y, makes this field an attribute. Otherwise, makes it an element. |
| 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. |
### Use case
Below is data that comes in a variety of classes and which needs to be stored as XML in a database. You want to turn the raw data into the database layout below.
#### Raw data
| Shape | Colour | Id | X | Y | Radius |
| ------ | ------ | -- | - | - | ------ |
| circle | blue | 1 | 3 | 5 | 5 |
| circle | red | 2 | 1 | 3 | 5 |
| circle | blue | 5 | 5 | 9 | 5 |
| circle | blue | 6 | 8 | 2 | 5 |
| circle | red | 7 | 9 | 7 | 5 |
| Shape | Colour | Id | X | Y | Length | Width |
| --------- | ------ | -- | - | - | ------ | ----- |
| rectangle | blue | 3 | 3 | 1 | 6 | 4 |
| rectangle | red | 6 | 2 | 4 | 6 | 4 |
| rectangle | blue | 10 | 8 | 2 | 6 | 4 |
| rectangle | red | 12 | 7 | 8 | 6 | 4 |
| rectangle | blue | 14 | 5 | 2 | 6 | 4 |
#### Output Sample
| Id | X | Y | Class data |
| -- | - | - | ------------------------------------------------------------------------------------------------- |
| 3 | 4 | 7 | \\blue\\ 5\\ |
| 1 | 6 | 3 | \\blue\\ 4\\ 6\\ |
| 2 | 8 | 8 | \\blue\\ 4\\6\\ |
| 5 | 5 | 2 | \\blue\\ 5\\ |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/addxml.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.