Weekly Challenge

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

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

Submit Feedback
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.

Challenge #37: Parsing a Raw XML File

Highlighted
Alteryx Partner

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

Highlighted
8 - Asteroid

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

 

Highlighted
Alteryx Partner

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

Highlighted
Alteryx Partner

Here's my solution to challenge 37!

Alteryx Certified Partner
Alteryx Certified Partner

Challenge #37, done.

 

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

 

Spoiler
Challenge_37.PNG

Cheers,

Highlighted
11 - Bolide

 

 

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

  

 

 

 

Highlighted
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

 

Highlighted
Alteryx
Alteryx

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

Highlighted
8 - Asteroid

Solved

Highlighted
8 - Asteroid