Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #214: US Military and High Points

Rob-Silk
8 - Asteroid

Solution attached below:

 

Spoiler
challenge_214_RS_screencap.PNG
danbostrom
8 - Asteroid

 

 

aatalai
15 - Aurora

C214

mgaronson
11 - Bolide
Spoiler
Challenge 214 Workflow Pic.jpg

 Lots of parsing!

Erin
11 - Bolide

The data prep on this one is a perfect use case for the tile tool (so often overlooked)! Made the data prep on this one a synch! 

 

Spoiler

The Tile_Num is unique to the state, and the Tile_SequenceNum is the row number for that state. Pairs well with crosstabs! 

214.png

 

 

Bobbyt23
13 - Pulsar

Found this one tough but great practice with REGEX_Replace

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Fun challenge. 

 

Trickiest part for me was remember how North/South/East/West convert to lat/longs. 

 

Good'ol bit of regex and data wrangling.

All the best,
BS

LinkedIN

Bulien
EdenTP
8 - Asteroid
Spoiler
 

image.png

KMan_
8 - Asteroid
Spoiler
{CF76CEA5-5F46-4201-B766-FA57DCEBDF2C}.png
thomasduong
8 - Asteroid

Here is my solution to Challenge #214. Enjoyed it very much, nice one!

Spoiler
Screenshot 2024-09-25 171522.png