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

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 #423: Wind Tower Proximity—Earth Day Special

AYXAcademy
Alteryx
Alteryx

c68b0ad7e10bc62108de889eff2c149c.jpgHi Maveryx,

 

A solution to last week’s challenge can be found here. 

 

Ellen Wiegand, a Senior Sales Engineer at Alteryx, brought us this brilliant challenge idea. We are truly grateful for your contribution, Ellen!

 

 

 

Considering the importance of renewable energy and to celebrate Earth Day, let's work on a challenge regarding sustainable energy! We have a dataset that provides detailed information about wind towers in the United States and its territories. The text input file contains the latitude and longitude coordinates for Alteryx headquarters in Irvine, California.

 

Looking only at wind towers with an Attribute Confidence of 3 and Projects with more than one wind tower, complete the following tasks. (Note: The Column Descriptors tool container in the workflow file contains the definitions of the values in the input dataset.)

  • What is the name of the project closest to the Irvine office (CA)?
  • How far away from the office is it?

 

Hint: The provided dataset is a flat file. To facilitate the data extraction, use the JSON Parse tool in the Developer tab of Designer.

 

Need a refresher? Review these lessons in Academy to gear up:

 

Sources:

 

Good luck!

 

AYXAcademy_0-1713381881710.png

alacoume
9 - Comet

My solution:

Spoiler
Challenge_423.jpeg
clmc9601
13 - Pulsar
13 - Pulsar

My solution. Fun spatial and parsing challenge!

 

Spoiler
 
Screenshot 2024-04-22 091041.png

.  

bgreedy
7 - Meteor

Fun times :)

 

Spoiler
Capture.PNG
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
423.jpg

AkimasaKajitani
17 - Castor
17 - Castor

My solution!!

 

Spoiler
スクリーンショット 2024-04-22 234113.png

Tofel
8 - Asteroid

No wind farms in south east US ? 😮

 

Spoiler
Challenge 423.JPG

acwysor
7 - Meteor
 

As someone who recently completed their Alteryx Advanced certification, this was a great test of in applying that knowledge to a real world problem!

 

Spoiler
Challenge 423 screenshot.png
acwysor
7 - Meteor

Great job!

logdog0411
9 - Comet
Spoiler

423 screenshot.png

Complete with pic of the Cabazon Dinosaur Park! 🐉

Fun fact: Marine training convoys from Camp Pendleton to 29 Palms routinely stop at Cabazon midway to rest and do repairs. So I have definitely driven past this windmill farm on many occasions... 

 

Semper Fidelis!

 

@joshuaburkhow @jaygarcia @JohnWheeler