Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #178: Chuck Like a Woodchuck

Highlighted
14 - Magnetar
14 - Magnetar

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).


Highlighted
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

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution

Highlighted
12 - Quasar

Challenge #178.PNG

Highlighted
Alteryx Partner
Spoiler
clipboard_image_0.png
Highlighted
11 - Bolide
11 - Bolide
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
Highlighted
Alteryx Certified Partner

It could chuck quite some wood.

Spoiler
178.png
Highlighted
8 - Asteroid

Somewhat unrealistic but fun one!

 

Spoiler

 

chuck.PNG

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

 

Highlighted
Alteryx
Alteryx

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

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

My solution