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 #116: A Symphony of Parsing Tools!

Highlighted
Alteryx Certified 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
13 - Pulsar

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
8 - Asteroid
 
Highlighted
8 - 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
8 - Asteroid

happy to learn about XML parse tool, thanks!

Highlighted
8 - 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
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
2020-01-25 09_24_46-Greenshot.png