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

Asteroid

My solution

Bolide
Bolide

Fun challenge!

Meteor
Spoiler
181 spoiler.PNG

Cool challenge. never used the download tool before!

Asteroid

Hey @T_Willins 

 

I totally get it now; it is basically matching the first instance of it and, of course, only grouping everything included on the matching group. This is really helpful. Just yesterday I was commenting this on our Phoenix User Group meeting with @michael_perillo and @wale_ilori 

 

Here is another example.

Meteor

Got to use one of my favorite tools

Spoiler
Used the text input into the download tool then the Downloaded into a string field.  Used the Json Parse to break it out and dynamic rename to kill some of the extra headers.  Split based on "." in the Json headers.  Since we are only getting one drink, we didn't need to use the outer record identifier.  Broke out ingredients and measurements and took row identifier from header.  Joined on row, filtered out null and empty values and selected only the fields I needed and renamed to correct header.  
I've done this with the Smartsheet API and it's great to build out your sheets and any metadata about them that you need like last updated at.  
Screen Shot 2019-09-18 at 4.23.00 PM.png

I need one of these, NOW!

Spoiler
clipboard_image_0.png
Alteryx Partner

clipboard_image_0.png

Hi everyone!

 

Here goes my first solution for the Weekly Challenge. I have started using Alteryx only this week, so hopefully will be able to get to the same result in fewer steps in future.

 

 

Asteroid

Quick, fun challenge! First time using JSON as well!

Meteoroid

Here is my solution