community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #181: Ingredients of an Old Southern

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
Meteor

Quick and Fun

Atom
 
Atom
Spoiler
Marina1_0-1573226590382.png

Thirsty work

Spoiler
Screenshot_2019-11-10 17.09.53_JTu8XW.png
Alteryx Partner

A bit unorthodox, but got the solution really quick

Alteryx Partner

Challenge 181 is done!

 

Spoiler
image.png
Meteor
Spoiler
LiD_0-1574117792573.png

Just love to use the RegEx tool, really cool! 

Meteoroid

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