We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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 #116: A Symphony of Parsing Tools!

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2023-09-05 191434.jpg

gawa
16 - Nebula
16 - Nebula

I want a HTML Parse tool

 

Hammad_Rashid
11 - Bolide

DataAnalyst23_0-1701323219730.png

 

RWvanLeeuwen
11 - Bolide

revisiting to prep for the designer expert exam

 

here's my take

Spoiler
I love the dummy row input to start processes 1 at a timeI love the dummy row input to start processes 1 at a timethe XML contains more data now so I filtered it down to selected datesthe XML contains more data now so I filtered it down to selected datesdownload and save to XML file locallydownload and save to XML file locally
Tgigs
8 - Asteroid

My solution attached.

 

Spoiler.PNG

karlhansen
9 - Comet
Spoiler
solution_116.png

The concerts in the solution only used the first one.  I condensed them into a single entry in the spirit of the solution.

CBUSYINZER
7 - Meteor

I couldn't get the same results as the solution, I am not sure what I did differently but I have most of the details.

Erin
11 - Bolide
Spoiler
116.png
Bobbyt23
13 - Pulsar

First time using the XML parse tool. Really interesting, quickly learnt to filter data as I went so it didn't go crazy.

FilipR
11 - Bolide

I think the solution overlooks cases with more than one concertInfo nested in the XML. Since this wasn't part of the requirement, I think it's a miss on the creator's part.

 

In my solution i got data from all concertInfo records.