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 #181: Ingredients of an Old Southern

maddyaustin
5 - Atom
Spoiler
181.png
SueDonim
8 - Asteroid

Nice quick one.

 

Spoiler
Process:
- Download tool
- JSON Parse (Output values into data type specific fields)
- Clean-up
- Filter out nulls (wasn't really necessary but makes it easier to read data you don't know)
- Filter out data with "Ingredient" in the name
- Filter out data with "Measure" in the name
- Add Record IDs to both threads
- Join on RecordID
- Clean-up


MySolution.PNG
Carlithian
11 - Bolide
11 - Bolide
 
fmvizcaino
17 - Castor
17 - Castor

Done!!!! 

 

Spoiler
fmvizcaino_0-1577384657799.png
Xiaoqi
7 - Meteor
 
jv1
8 - Asteroid
Spoiler
jv1_0-1577709216660.png
Neetu
8 - Asteroid
 
rmassambane
10 - Fireball
 
ponraj
13 - Pulsar

Here is my solution

 

Spoiler
Capture.PNG
AndrewS
11 - Bolide

#181