Mapping and transforming XML data

The following scenario creates a three-component Job that maps and transforms data from an
XML source file Customer.xml, and generates an XML output flow which
could be reused for various purposes, such as for an ESB request, in the future based on the
XML tree structure of the file Customer_State.xml.

These three components are:

tFileInputXML: provides the input data to
tXMLMap.
tXMLMap: maps and transforms the received XML
data flows into one single XML data flow.
tLogRow: displays the output data.

The content of the XML file Customer.xml is as follows:

&lt;?xml version="1.0" encoding="ISO-8859-15"?&gt;
&lt;Customers&gt;
	&lt;Customer RegisterTime="2001-01-17 06:26:40.000"&gt;
		&lt;Name&gt;
			&lt;id&gt;1&lt;/id&gt;
			&lt;CustomerName&gt;Griffith Paving and Sealcoatin&lt;/CustomerName&gt;
		&lt;/Name&gt;
		&lt;Address&gt;
			&lt;CustomerAddress&gt;talend@apres91&lt;/CustomerAddress&gt;
			&lt;idState&gt;2&lt;/idState&gt;
		&lt;/Address&gt;
		&lt;Revenue&gt;
			&lt;Sum1&gt;67852&lt;/Sum1&gt;
		&lt;/Revenue&gt;
	&lt;/Customer&gt;
	&lt;Customer RegisterTime="2002-06-07 09:40:00.000"&gt;
		&lt;Name&gt;
			&lt;id&gt;2&lt;/id&gt;
			&lt;CustomerName&gt;Bill's Dive Shop&lt;/CustomerName&gt;
		&lt;/Name&gt;
		&lt;Address&gt;
			&lt;CustomerAddress&gt;511 Maple Ave. Apt. 1B&lt;/CustomerAddress&gt;
			&lt;idState&gt;3&lt;/idState&gt;
		&lt;/Address&gt;
		&lt;Revenue&gt;
			&lt;Sum1&gt;88792&lt;/Sum1&gt;
		&lt;/Revenue&gt;
	&lt;/Customer&gt;
	&lt;Customer RegisterTime="1987-02-23 17:33:20.000"&gt;
		&lt;Name&gt;
			&lt;id&gt;3&lt;/id&gt;
			&lt;CustomerName&gt;Glenn Oaks Office Supplies&lt;/CustomerName&gt;
		&lt;/Name&gt;
		&lt;Address&gt;
			&lt;CustomerAddress&gt;1859 Green Bay Rd.&lt;/CustomerAddress&gt;
			&lt;idState&gt;2&lt;/idState&gt;
		&lt;/Address&gt;
		&lt;Revenue&gt;
			&lt;Sum1&gt;1225.&lt;/Sum1&gt;
		&lt;/Revenue&gt;
	&lt;/Customer&gt;
	&lt;Customer RegisterTime="1992-04-28 23:26:40.000"&gt;
		&lt;Name&gt;
			&lt;id&gt;4&lt;/id&gt;
			&lt;CustomerName&gt;DBN Bank&lt;/CustomerName&gt;
		&lt;/Name&gt;
		&lt;Address&gt;
			&lt;CustomerAddress&gt;456 Grossman Ln.&lt;/CustomerAddress&gt;
			&lt;idState&gt;3&lt;/idState&gt;
		&lt;/Address&gt;
		&lt;Revenue&gt;
			&lt;Sum1&gt;64493&lt;/Sum1&gt;
		&lt;/Revenue&gt;
	&lt;/Customer&gt;
&lt;/Customers&gt;

<?xml version="1.0" encoding="ISO-8859-15"?>

<Name>

<CustomerName>Griffith Paving and Sealcoatin</CustomerName>

</Name>

<CustomerAddress>talend@apres91</CustomerAddress>

</Address>

</Revenue>

</Customer>

<Name>

</Name>

<CustomerAddress>511 Maple Ave. Apt. 1B</CustomerAddress>

</Address>

</Revenue>

</Customer>

<Name>

<CustomerName>Glenn Oaks Office Supplies</CustomerName>

</Name>

<CustomerAddress>1859 Green Bay Rd.</CustomerAddress>

</Address>

</Revenue>

</Customer>

<Name>

</Name>

<CustomerAddress>456 Grossman Ln.</CustomerAddress>

</Address>

</Revenue>

</Customer>

</Customers>

The content of the XML file Customer_State.xml is as
follows:

&lt;?xml version="1.0" encoding="ISO-8859-15"?&gt;
&lt;customers&gt;
	&lt;customer id="1"&gt;
		&lt;CustomerName&gt;Griffith Paving and Sealcoatin&lt;/CustomerName&gt;
		&lt;CustomerAddress&gt;talend@apres91&lt;/CustomerAddress&gt;
		&lt;idState&gt;2&lt;/idState&gt;
	&lt;/customer&gt;
	&lt;customer id="2"&gt;
		&lt;CustomerName&gt;Bill's Dive Shop&lt;/CustomerName&gt;
		&lt;CustomerAddress&gt;511 Maple Ave.  Apt. 1B&lt;/CustomerAddress&gt;
		&lt;idState&gt;3&lt;/idState&gt;
	&lt;/customer&gt;
&lt;/customers&gt;

<?xml version="1.0" encoding="ISO-8859-15"?>

<CustomerName>Griffith Paving and Sealcoatin</CustomerName>

<CustomerAddress>talend@apres91</CustomerAddress>

</customer>

<CustomerAddress>511 Maple Ave. Apt. 1B</CustomerAddress>

</customer>

</customers>

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 6.x

0 Comments

Inline Feedbacks

View all comments

Mapping and transforming XML data – Docs for ESB 6.x

Mapping and transforming XML data

My Website Links

Tags