Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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
13 - Pulsar

 

 

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
14 - Magnetar
14 - Magnetar

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 Alumni (Retired)

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

rachelgatto
8 - Asteroid

Solved

bkclaw113
9 - Comet