Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #37: Parsing a Raw XML File

dheissner
Alteryx
Alteryx

Keep it simple and use the XML Parse tool on the bill_to and then ship_to data... 

 

Spoiler
dheissner_0-1631027766599.png

 

TimN
13 - Pulsar
Spoiler
TimN_0-1632358833839.png

 

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1633458323763.pngjjrbondoc_1-1633458352739.png

 

 

LiuZhang
9 - Comet
Spoiler
37.png
jonathanwillis
8 - Asteroid

Here's my solution

ARussell34
8 - Asteroid

It helps to change the source when trying to use the xml parse tool. After much frustration in the beginning I was able to develop a basic understanding of the child and root terms to be able to get the correct "child" output and then was able to multi-join all the data back together by the original record ID I used at the beginning of the workflow.

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution:

Supergiant
8 - Asteroid

My first attempt on Parsing XML File! Great fun!

 

Spoiler
Supergiant_0-1640603585035.png

 

davidhardister
8 - Asteroid

davidhardister_0-1641142350159.png

 

AndrewSu
Alteryx
Alteryx

my take 🙂