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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #178: Chuck Like a Woodchuck

Pulsar

image.png

And it's clearly much simpler to do with Alteryx

 

Spoiler
Went for economy of tools this time. 

image.png

While you don't need to separate out the soil type (thank you, Find and Replace!!), you do need the percent piece (used Regex_Replace, though text functions would work equally well).


Alteryx Certified Partner

A woodchuck would chuck as much wood as a woodchuck could chuck if a woodchuck could chuck wood

 

 

Spoiler
Otherwise, approximately 22.3 cubic feet of wood per day - assuming a 7 day work week for woodchucks and sufficient wood to chuck

Snag_1f52198b.png

 

 

Bolide

My solution

Quasar

Challenge #178.PNG

Alteryx Partner
Spoiler
clipboard_image_0.png
Comet
Spoiler
My solution, probably too many tools to get the soil  weights when it could be summarised a lot earlier than I did.

Challenge 178.PNG
Alteryx Certified Partner

It could chuck quite some wood.

Spoiler
178.png
Asteroid

Somewhat unrealistic but fun one!

 

Spoiler

 

chuck.PNG

Really brings out the usefulness of the text-to column tool.

 

Alteryx
Alteryx

Challenge completed, hardest part was understanding my cubic feet measurements!

Alteryx Partner
Spoiler
Annotation 2019-08-27 131612.png

My solution