Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

ncrlelia
11 - Bolide

Challenge 037

RashedDS
8 - Asteroid

My short solution

Spoiler
RashedDS_0-1626995513884.png

 

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-24 124812.png

I used the XML parsing tool for the first time while trying to follow the suggested instructions in the challenge post! However, the updated solution doesn't use it all. 🤣

 

The instructions in the challenge post mentioned 26 fields but the solution only showed 25. I left in the "Reference" field to get to 26. I also chose not to format the phone numbers as billions or trillions and left them as a string.

carmenrapariz
8 - Asteroid
Spoiler
Challenge 37.PNG
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

No xml tool but I didn't read the initial post... 

 

Emil_Kos_0-1628190504156.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 37.PNG
Kevin_VANCAPPEL
10 - Fireball

Hello,

 

  here is my proposal.

 

  Regards,

  Kévin V.

DanTh
Alteryx
Alteryx
Spoiler
Used the "<" and ">" delimiters to split to rows and then reconstruct after Transpose tool.

5/5

Jotigautam
10 - Fireball

Solution

Spoiler
Jotigautam_0-1630069688690.png

 

oly
Alteryx Alumni (Retired)

Spoiler