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 #93: Pumpkin Production

Asteroid
Spoiler
clipboard_image_0.png
Asteroid

Overly complicated my solution, might try and get it down to fewer tools...

Spoiler
clipboard_image_0.png

Solution attached

Highlighted
Meteoroid

A lot of joins. Maybe there's a better way?

Asteroid
 
Meteor
Spoiler
Workflow Picture.PNG

Decided to do it two different ways. One with the sorting attempt used by Patrick and then the way using summarize which was more natural to me.

Alteryx Partner

Fun exercise - I'm happy with my solution this time (at least I am before looking at the others)

 

 

Spoiler
What I learned:
- ReplaceChar function (for getting rid of pesky commas)
- Dynamic Rename (had used once, but forgot it)
- At least a couple of uses of Sample tool
- Careful design can simplify process (duh!)

Process:
- Remove commas from data
- Padleft State ANSI code
- Convert string to number
- Separate piped data into columns
- Change first record to field names with Dynamic Renaming tool
- Joined data on State ANSI code
- Summary tool to calculate average production by state (Group by State, then calculate average) - really only needed one of these tools rather than two
- Join data together with data in an upper stream and a lower stream
- Sort data by year and by production (descending)
- Sample Top 1 from upper stream (for Max)
- Sample Bottom 1 from lower stream (from Min)
- Cleanup fields
- Calculate difference from average for each stream
- Join data into single table

MySolution.PNG

 

 

Meteor
 
Alteryx Partner

Here is my solution !

Asteroid

Here is my long-winded but complete solution!