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.

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

OllieClarke
13 - Pulsar
13 - Pulsar
TonyA
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.

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

 

Luisa_Bez
8 - Asteroid
 
KMiller
8 - Asteroid

Solution attached.

Spoiler
12-11-2019 12-14-20.png
RWvanLeeuwen
10 - Fireball

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

 

Spoiler
116.jpg
nini
8 - Asteroid

happy to learn about XML parse tool, thanks!

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