We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #37: Parsing a Raw XML File

sachin02
8 - Asteroid

My solution : (although have not renamed the columns as per in the output )

Sajeel_Kershi
8 - Asteroid

completed using 5 xml parse tools (pity there is'nt an option to expand xml structure in one step)

 

FeedMeData
8 - Asteroid

Never done XML parsing before so I needed a some help on this one

JonathanAllenby
8 - Asteroid

Here's my solution to challenge 37!

Thableaus
17 - Castor
17 - Castor

Challenge #37, done.

 

Did not use XML Parse Tool, I chose to parse this as a flat file.

 

Spoiler
Challenge_37.PNG

Cheers,

kelly_gilbert
12 - Quasar

 

 

I went a little crazy trying to dynamically rename and order the fields to match the output!

 

Spoiler

 challenge_37_workflow_1.PNG

 challenge_37_workflow_2.PNG

 

 

 challenge_37_workflow_3.PNG

  

 

 

 

T_Willins
13 - Pulsar
13 - Pulsar

Tried to use as few tools as possible.  Used the ability to rename in Join Multiple tool to correct names.  Naming connections before joining helps keep track of inputs to select for Join Multiple output.

 

Spoiler
Workflow 37.GIF

 

TonyA
Alteryx
Alteryx

Here's my solution. Not quite as efficient as the provided solution but a great learning exercise.

rachelgibbons
8 - Asteroid

Solved

bkclaw113
8 - Asteroid