Executing the XML2view Transform
For this portion of the tutorial, you will be provided with the XML data to copy and paste into the parameter input window so that you can validate how the transform will perform when given data.
To execute the XML2TBL transform
1. Open your transform and click Execute.
2. Copy the following XML into the Input Values for XML2view window:
<?xml version="1.0" encoding="utf-8"?>
<CustomersParam xmlns:foo="foo">
<foo:customer>
<foo:customerID>1</foo:customerID>
<foo:customerName>Able Computing</foo:customerName>
<foo:customerEmail>compositesw.com</foo:customerEmail>
<foo:orders>
<foo:orderID>2</foo:orderID>
<foo:orderSubTotal>232.6</foo:orderSubTotal>
<foo:orderSalesTax>99.9</foo:orderSalesTax>
<foo:orderTotal>88.34</foo:orderTotal>
<foo:orderSubmitDate>2013-1-6</foo:orderSubmitDate>
<foo:orderProcessDate>2013-3-9</foo:orderProcessDate>
<foo:orderShipDate>2013-4-5</foo:orderShipDate>
<foo:orderItems>
<foo:orderItemID>1009</foo:orderItemID>
<foo:orderItemName>ldap</foo:orderItemName>
<foo:orderItemDescription>this is a cumputer.</foo:orderItemDescription>
<foo:orderItemQuantity>much good</foo:orderItemQuantity>
<foo:orderItemPrice>99.9</foo:orderItemPrice>
</foo:orderItems>
</foo:orders>
</foo:customer>
</CustomersParam>
3. Paste it into the Customers field.
4. Click OK to display the Result panel.
5. Click Display to view the data.