Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #116: A Symphony of Parsing Tools!

Highlighted
Alteryx Partner
Highlighted
Alteryx
Alteryx

 I did it without the XML parser and was happy to see others use that tool so I could understand it better. I did notice that the XML Parser solutions I looked used a lot fewer tools but took a minute or two to run while mine takes 2.2 seconds. Then again mine took a couple of hours to build.

Highlighted
Quasar

I tried both RegEx and XML Parse tools and neither matched the given solution.  Looked at the downloaded data and there are discrepancies there, so I think the starting data is different now.  Kept the RegEx workflow as it is much faster.

 

Spoiler
Workflow 116.JPG

 

Highlighted
Asteroid
 
Highlighted
Asteroid

Solution attached.

Spoiler
12-11-2019 12-14-20.png
Highlighted
Alteryx Certified Partner

A large amount of effort went into parse this data, but when it's done it is very rewarding.

 

Spoiler
116.jpg
Highlighted
Asteroid

happy to learn about XML parse tool, thanks!

Highlighted
Asteroid

Here's my Effort. Doesn't quite match the provided answer, but as others have commented, it looks like the source data has changed slightly

Spoiler
JamesCameron_0-1579288524319.png
Asteroid
 
Highlighted
Asteroid
Spoiler
2020-01-25 09_24_46-Greenshot.png