This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Alteryx cannot read the extract you have attached because it doesn't have the completed tags. Can you send the full file? Have you tried reading it in as a non delimited CSV and parsing it yourself using XML parse?
You would still download it as an XML but in the input tool you can change what format you want to read it in as. If you select CSV here you can then change the delimiter to \0 (non delimited). Once Alteryx has read it in this format you can use the Alteryx parsing tools to extract the relevant data. I have used a tool called Parse XML which i downloaded form Alteryx.gallery.com but there is one out of the box called XML Parse.