Alteryx having trouble reading an XML file that is readable by Excel

lucasyliu

Alteryx seems having trouble reading an XML file where it opens fine in Excel. See attached.

Can anyone enlighten me?

RPT_SAMPLE.zip

Input

Accepted answers

BrandonB

I mocked up a quick example of pulling this data out. Take a look at the attached workflow. There may be a more elegant solution but this is quick and gets the job done.

xml parse 1.png

XML Parse 2.png

XML Parse.yxmd

All comments

BrandonB

I was able to pull the data in the Excel file by specifying that I wanted the XML Child Element Name "Data". Alteryx is going to allow you to read in ALL of the XML, not just the data fields that you are seeing in Excel, so it will also include things like styling, fonts, etc.

benakesh

Hi @lucasyliu ,

How was this xml file created ?

This works : Open this xml file in excel and save as 'xlsx' and then Alteryx can read xlsx file .

BrandonB

I mocked up a quick example of pulling this data out. Take a look at the attached workflow. There may be a more elegant solution but this is quick and gets the job done.

xml parse 1.png

XML Parse 2.png

XML Parse.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703