Hi All, I need some help in extracting the xml file (mostly it is very huge file) with multiple child tags. I tried all options given in the https://help.alteryx.com/current/ReadingXML.htm, but unable to figure it out. Input 1234 abcd xyz MEZA MR 5678 Maria xyz Agnes MR 9234 abcd xyz MEZA MR 5978 Maria xyz Agnes MR Table EmplyeeIDFirstNameMiddleNameLastNameSuffixFamilyIDFamilyFirstNameFamilyMiddleNameFamilyLastNameFamilySuffix1234 5678 9234 5978

XML parsing - unable to get all fields

Hi All,

I need some help in extracting the xml file (mostly it is very huge file) with multiple child tags. I tried all options given in the https://help.alteryx.com/current/ReadingXML.htm, but unable to figure it out.

Input

<Employee>
<EmployerID>1234</EmployerID>
<FirstName>abcd</FirstName>
<MiddleName>xyz</MiddleName>
<LastName>MEZA</LastName>
<Suffix>MR</Suffix>
<Family>
<FamilyID>5678</FamilyID>
<FamilyFirstName>Maria</FamilyFirstName>
<FamilyMiddleName>xyz</FamilyMiddleName>
<FamilyLastName>Agnes</FamilyLastName>
<FamilySuffix>MR</FamilySuffix>
</Family>
</Employee>
<Employee>
<EmployerID>9234</EmployerID>
<FirstName>abcd</FirstName>
<MiddleName>xyz</MiddleName>
<LastName>MEZA</LastName>
<Suffix>MR</Suffix>
<Family>
<FamilyID>5978</FamilyID>
<FamilyFirstName>Maria</FamilyFirstName>
<FamilyMiddleName>xyz</FamilyMiddleName>
<FamilyLastName>Agnes</FamilyLastName>
<FamilySuffix>MR</FamilySuffix>
</Family>
</Employee>

Table

EmplyeeID	FirstName	MiddleName	LastName	Suffix	FamilyID	FamilyFirstName	FamilyMiddleName	FamilyLastName	FamilySuffix
1234					5678
9234					5978

Help

Accepted answers

DavidP

Based on the data you pasted in your 1st post, does this work for you?

xml parse to table.yxzp

All comments

DavidP

I've used this macro before when I just wanted to pull all the child tags into a flat structure.

Parse+XML.yxzp

Naga

Thanks @DavidP for the quick solution - Just want to check what configuration you used for the XML input file configuration

DavidP

Hi @Rehat

Attached is a packaged workflow that reads and flattens your xml file with the parse XML macro.

Let me know if this is what you're looking for.

If you're on an older version of Alteryx, you may get an error when double clicking the yxzp file. However, look in your downloads folder as it would have unzipped itself into a folder from where you should be able to run it.

read xml with parse xml macro.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703