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 #214: US Military and High Points

Highlighted
Alteryx
Alteryx

Not the simplest solution but a robust one.

 

Spoiler
workflow.png
Florian Carrier
Solutions Engineer
Alteryx
Highlighted
7 - Meteor
Spoiler
 

lazy guy answer without too much formula. could reduce 2/3 of the workflow using the formulas. Make columns could be used for more efficiency 

Runtime is not that bad tho. 

Highlighted
8 - Asteroid

This was a fun one! First time using spatial plotting, but I figured it out.

Spoiler
Maskell_Rascal_0-1588621707749.png

 

Highlighted
6 - Meteoroid

My solution - I try to use as basic a tool as possible, in the most basic, step-by-step way as I use these challenges as a fun way to train up the rest of my team.

 

Spoiler
214.png

 

Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1588624660796.png

 

Highlighted
Alteryx
Alteryx

I misunderstood the third question and assumed that "neighboring" meant "adjacent." So I solved for that first then checked the solution and realized the question just meant in another state. So both solutions are shown below.

Spoiler
2020-05-04_14-34-14.png
Highlighted
Alteryx Partner

Thanks @Blake

I got it, just had some spare time to kill :'-) 

Thanks for the submission :folded-hands:

 

(edit : it seems emojis are not rendering properly) 

Highlighted
8 - Asteroid

Cool topic learning about the highest peaks in the U.S.

Spoiler
2020-05-04 19_06_15-Greenshot.png
Highlighted
8 - Asteroid

@patrick_digan your solution file is a blank start file.  I am interested in seeing the inner workings of your formula tool in the Highest Peak transformation.  Can you please reattach when you get a chance?

8 - Asteroid

Good Exercise for Data Preparation, Data Analysis and Spatial