Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

kirk_yates
6 - Meteoroid
Spoiler
Download tool
to JSON parse
to Formula breaking the Json Name to what will become columns and headers
to Filter tool to show only my ingredients & measures and remove null rows
to Crosstab to to move my columns to columns and rows to rows
benbenjoy
8 - Asteroid

Quick and Fun

marinacarr
5 - Atom
 
marinacarr
5 - Atom
Spoiler
Marina1_0-1573226590382.png
SimonSturges
7 - Meteor

Thirsty work

Spoiler
Screenshot_2019-11-10 17.09.53_JTu8XW.png
MFish
8 - Asteroid

A bit unorthodox, but got the solution really quick

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 181 is done!

 

Spoiler
image.png
LiD
8 - Asteroid
Spoiler
LiD_0-1574117792573.png

Just love to use the RegEx tool, really cool! 

tiffany_chen
8 - Asteroid

In this case, we should also consider if there's more than one drink(in this case, there's only one drink 0), does our solution still work? And if the ingredient and measure's sequence in json file is not exactly match, will join based on position still work? So, I think the standard solution should be improved.

Spoiler
2019-11-20_141918.png
soha-elghany
8 - Asteroid