Hi, I'm trying to parse XML that I'm getting as a response to an API call. The structure of the XML is the following for each row of data: First_Name Phil Date_of_Application 01/01/2000 First_Name Joe Date_of_Application 01/01/2000 Using the XML parse tool with the following settings ... I'm getting back data that in this format ... NameValueFirst_NamePhilDate_Of_Application01/01/2000First_NameJoeDate_Of_Application 01/01/2000 However what I'm after is data in this format ... First_NameDate_Of_ApplicationPhil01/01/2000Joe01/01/2000 I've tried stringing together multiple parse XML tools with just about every combination of Child name/values but I'm not able to figure it out. Any suggestions?

Parse XML question

Hi, I'm trying to parse XML that I'm getting as a response to an API call. The structure of the XML is the following for each row of data:

<Results>
	<Properties>
		<Property>
			<Name>First_Name</Name>
			<Value>Phil</Value>
		</Property>
		<Property>
			<Name>Date_of_Application</Name>
			<Value>01/01/2000</Value>
		</Property>
	</Properties>
</Results>
<Results>
	<Properties>
		<Property>
			<Name>First_Name</Name>
			<Value>Joe</Value>
		</Property>
		<Property>
			<Name>Date_of_Application</Name>
			<Value>01/01/2000</Value>
		</Property>
	</Properties>
</Results>

Using the XML parse tool with the following settings ...

I'm getting back data that in this format ...

Name	Value
First_Name	Phil
Date_Of_Application	01/01/2000
First_Name	Joe
Date_Of_Application	01/01/2000

However what I'm after is data in this format ...

First_Name	Date_Of_Application
Phil	01/01/2000
Joe	01/01/2000

I've tried stringing together multiple parse XML tools with just about every combination of Child name/values but I'm not able to figure it out. Any suggestions?

Parse

Transformation

API

Accepted answers

T_Willins

Hi @DSnyder1,

Sometimes it is difficult to get the XML to parse exactly as you want it. Utilizing other Alteryx tools as below will give you the result you are looking for.

Cleanse XML parse.png

Cleanse XML parse.yxmd

All comments

T_Willins

Hi @DSnyder1,

Sometimes it is difficult to get the XML to parse exactly as you want it. Utilizing other Alteryx tools as below will give you the result you are looking for.

Cleanse XML parse.png

Cleanse XML parse.yxmd

fmvizcaino

Hi @DSnyder1 ,

Would you be able to share a small sample of you file in xml format?

Then I can check it out and try to solve it 🙂

Best,

Fernando Vizcaino

DSnyder1

Thanks @T_Willins, this worked perfectly.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703