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 #226: Flex-Ability

7 - Meteor

Fun challenge

Spoiler
Challenge_226.PNG

 

8 - Asteroid
Spoiler
2020-07-30 08_20_26-Greenshot.png
7 - Meteor
Spoiler
WJJW-1_0-1596120916056.png

 

My solutions got shorter the more I thought about it.

5 - Atom

Here's my solution 🙂

ewelinak_0-1596123450397.png

 

Alteryx
Alteryx
Spoiler
RobertW_0-1596127089189.png

 

I was surprised at how easy the summarize tool worked.

 

 

After looking at other solutions it may not be clear that I used the Summarize to create a centroid given all the points in one column.  

 

  1. Use the Formula tool to create a line, create a centroid, and then convert to string
  2. Spatial Tool, built line, create centroid
  3. Summarize tool to create centroid, convert to string, regex to extract coords

Never even thought it could be so easy to average the coords, but makes some sense.  I wonder how accurate it is given that'd be 2d planar, but the earth is a sphere.  Probably be more accurate to use a Great Circle.

 

For the curious the Great Circle mid point would be...

N 36 58 24.87 , W 111 44 9.65

http://www.onlineconversion.com/map_greatcircle_distance.htm

Alteryx Certified Partner

C226 was solved, thanks!

Spoiler
Way 1: X = (x1+x2)/2, Y = (y1+y2)/2
Way 2: Build a line from 2 point then using Spatial Info to find Centroid
Way 3: Intersection of circle having Irvine centroid and radius = 1/2 distance from 2 points
Capture.PNG
10 - Fireball

Really fun challenge!  Two methods came to mind immediately.  The third is a little wacky in comparison but gets it done!  I'm excited to go see other people's methods.

 

Spoiler
226EW.PNG
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 226 is done! I can't resist spatial calcs in the formula tool!

 

Spoiler
Jonathan-Sherman_0-1596139795846.png

 

13 - Pulsar
13 - Pulsar

Here are my solutions. 

 

Spoiler
Workflow 226.png

 

6 - Meteoroid
Spoiler
Spoiler
nithink_0-1596178803645.png