Alteryx having trouble reading an XML file that is readable by Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx seems having trouble reading an XML file where it opens fine in Excel. See attached.
Can anyone enlighten me?
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Excellent, thanks so much for the quick turnaround!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Quick followup, I ran into another problem using actual data, where there is a header containing string "&" symbol. What is the proper way to handle XML with "&" symbol in Alteryx? Sample data attached.
I checked the "Ignore XML Errors and Continue" box to bypass the error, the result is the header "ItemA&E" is missing the "&E" portion.
