Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #226: Flex-Ability

johnemery
11 - Bolide

Interesting challenge. It's always fun to try to find different solutions to the same problem.

 

Spoiler
1) Use the summarize tool to calculate the average of each coordinate field.
2) Create spatial points, build a polyline, find the centroid of that line.
3) Calculate the arithmetic mean of each coordinate field using a multi-row formula tool, then return only the appropriate record.

Solution.PNG
PatrickB89
7 - Meteor

Solution #226:

 

Spoiler
PatrickB89_0-1596464667176.png

 

blarby
5 - Atom
Spoiler
blarby_2-1596471680067.png

 

Bit late to the party but really enjoyed this one!

 

kelly_gilbert
13 - Pulsar

Another fun one! My solutions are pretty similar to the rest.

 

Spoiler
This was a good challenge for experimenting with the spatial functions in the Summarize and Formula tools.

kelly_gilbert_0-1596550994679.png

 

jgosalia
7 - Meteor

Spoiler

DBoyer
7 - Meteor

I do most spatial work in GIS, so this took a little longer than it should after some inspiration from others. 

 

Spoiler
C226.JPG

JohanRanschaert
8 - Asteroid
Spoiler
JohanRanschaert_0-1596794740577.png

 

In attach my solution

sumanthskumar
8 - Asteroid

Challenge #54

Spoiler
sumanthskumar_0-1597127180244.png

 

JennyMartin
9 - Comet

 

Spoiler
AWC226.PNG

Definitely overcomplicated this initially so a great challenge for learning more about spatial. Video solution here: https://www.youtube.com/watch?v=C4WHs_V_iMw&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=30

 

This challenge is great for understanding how to work with spatial data! Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-226-Flex-Ability/td-p/610213
pasccout
8 - Asteroid

Found 3 solutions... 2 exact... one very close...