<?xml version="1.0" encoding="UTF-8"?>
<document>
    <product>
        <id>1</id>
        <name>milk</name>
        <size>16 oz</size>
    </product>
    <product>
        <id>2</id>
        <name>water</name>
        <size> 8 oz</size>
    </product>
</document>

Source transformation

Configure the Source transformation to read data from the file that contains the file path, and configure the source formatting options.

On the

Source

tab, select a connection that can access the source file, set the source type to

Single Object

, and select filepath.txt as the source object.

Click

Formatting Options

and then configure the following properties:

Property	Value
Flat File Type	Delimited
Text Qualifier	None
Field Labels	Auto-generate
First Data Row	1

Velocity transformation

Configure the Velocity transformation input and create the template.

On the

Input Format

tab, configure the following properties:

Property	Value
Input Field	Incoming string field from the Source transformation.
Input Type	File
Format Type	XML
Variable Name in Template	root
Code Page	UTF-8

On the

Velocity Template

tab, enter the following template in the template editor and validate the syntax:

<?xml version="1.0" encoding="UTF-8"?>
<!--Generation date: $function.call('Systimestamp')-->
## Convert each product to an element:
<products>
#foreach ($child in $root.getRootElement().getChildren() )
    <$child.getChild("name").getText()>
        <id>$child.getChild("id").getText()</id>
        <size>$child.getChild("size").getText()</size>
    </$child.getChild("name").getText()>
#end
</products>

Target transformation

Configure the Target transformation to write data to a flat file target created at run time. To ensure that the target file contains no header and no text qualifier character, configure the formatting options.

On the

Target

tab, select the connection and set the target type to

Single Object

. Click

Select

next to the

Object

field. Select

Create New at Runtime

, and enter the file name "products_converted.xml."

Click

Formatting Options

and set the text qualifier to

None

.

In the Advanced properties, set the header options to

No Header

.

<?xml version="1.0" encoding="UTF-8"?>
<!--Generation date: 06/17/2020 17:45:41.341526-->
<products>
    <milk>
        <id>1</id>
        <size>16 oz</size>
    </milk>
    <water>
        <id>2</id>
        <size> 8 oz</size>
    </water>
</products>