Reading XML

<items>
	<item id="01" type="Donut">
		<name>Cake</name>
		<ppu>0.60</ppu>
		<batters>
			<batter id="10">Regular</batter>
			<batter id="11">Chocolate</batter>
			<batter id="12">Blueberry</batter>
			<batter id="13">Devil's Food</batter>
		</batters>
		<topping>
			<topping id="100">None</topping>
			<topping id="101">Glazed</topping>
			<topping id="102">Sugar</topping>
			<topping id="103">Powdered Sugar</topping>
			<topping id="104">Chocolate</topping>
			<topping id="105">Chocolate with Sprinkles</topping>
			<topping id="106">Maple</topping>
		</topping>
	</item>
	<item id="02" type="Donut">
		<name>Raised</name>
		<ppu>0.65</ppu>
		<batters>
			<batter id="10">Regular</batter>
		</batters>
		<topping>
			<topping id="100">None</topping>
			<topping id="101">Glazed</topping>
			<topping id="102">Sugar</topping>
			<topping id="104">Chocolate</topping>
			<topping id="106">Maple</topping>
		</topping>
	</item>
	<item id="03" type="Donut">
		<name>Buttermilk</name>
		<ppu>0.50</ppu>
		<batters>
			<batter id="10">Regular</batter>
			<batter id="11">Chocolate</batter>
		</batters>
	</item>
</items>

Specifying an XML Child Element Name causes Alteryx to read the file from the element.

These settings applied to the example XML input generate the following results:

These results:

• do not contain the root element.
• do not contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• contain the child elements of a specified element.
• do not contain tag formatting.

Select Return Root Element to return the parent element that encloses all other represented elements.

These settings applied to the example XML input generate the following results:

These results:

• contain the root element.
• contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• do not contain the child elements of a specified element.
• do not contain tag formatting.

Child element name

Specifying an XML Child Element Name does not change the results. Alteryx prioritizes reading the root element.

Deselect Return Child Values to return only the child values of the root element.

These settings applied to the example XML input generate the following results:

These results:

• do not contain the root element.
• contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• do not contain the child elements of a specified element.
• do not contain tag formatting.

Child element name

Specifying an XML Child Element Name causes Alteryx to read the file from the specified element.

Configuration option	Setting
Return Root Element	Deselected
XML Child Element Name	"topping"
Return Child Values	Deselected
Return Outer XML	Deselected

These settings applied to the example XML input generate the following results:

topping

These results:

• do not contain the root element.
• do not contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• do not contain the child elements of a specified element.
• do not contain tag formatting.

Select Return Outer XML to create additional columns containing the tag format of the child elements.

These settings applied to the example XML input generate the following results:

These results:

• do not contain the root element.
• do not contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• do not contain the child elements of a specified element.
• contain tag formatting.

Child element name

Specifying an XML Child Element Name causes Alteryx to read the file from the specified element.

Configuration option	Setting
Return Root Element	Deselected
XML Child Element Name	"topping"
Return Child Values	Selected
Return Outer XML	Selected

These settings applied to the example XML input generate the following results:

topping	topping_1	topping_1_id	topping_1_OuterXML	topping_2	topping_2_id	topping_2_OuterXML	topping_3	topping_3_id	topping_3_OuterXML
	None	100	<topping id="100">None</topping>	Glazed	101	<topping id="101">Glazed</topping>	Sugar	102	<topping id="102">Sugar</topping>
	None	100	<topping id="100">None</topping>	Glazed	101	<topping id="101">Glazed</topping>	Sugar	102	<topping id="102">Sugar</topping>
	Chocolate	104	<topping id="104">Chocolate</topping>	Maple	106	<topping id="106">Maple</topping>	[Null]	[Null]	[Null]
	Glazed	101	<topping id="101">Glazed</topping>	Sugar	102	<topping id="102">Sugar</topping>	[Null]	[Null]	[Null]
	Glazed	101	<topping id="101">Glazed</topping>	Powdered Sugar	103	<topping id="103">Powdered Sugar</topping>	Chocolate	104	<topping id="104">Chocolate</topping>

These results:

• do not contain the root element.
• do not contain the child elements of the root element.
• do not contain the grandchild elements of the root element.
• contain the child elements of a specified element.
• contain tag formatting.