Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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