The link to the solution for last challenge #36 is HERE.
Using raw XML files as input can present some interesting challenges. The challenge is that the data is nested into the records in a way that requires you to extract it through parsing steps, sometimes drilling many levels into the data (Root and child levels). Alteryx makes this easier to do using the XML Parsing tool. We will explore the process in this exercise.
Use Case: A company receives customer purchase and shipping data on a weekly level based on web and catalog purchases. The company would like to analyze their customers and produce a profile by market by SKU. The challenge is that the data feed contains XML that needs to be parsed in order effectively analyze the data.
Objective: The column called customer_OuterXML contains the data that needs to be parsed into 26 unique fields detailing the customer contact information for both the “Bill To” and “Ship To” attributes.
My solution was similar to @Naledi
Thank you for the exercise