Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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 #421: Which US city could observe solar eclipses in both 2023 and 2024?

RWvanLeeuwen
11 - Bolide

here we go:

Spoiler
421.png

not sure about that missing bracket though... I did not fix the data quality with Alteryx, because I'd rather discuss a fix in the source

messi007
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
Capture_20240409.PNG
olga_strubbe
11 - Bolide

This was a fun challenge, thank you @gawa!

And a great practice for spatial tools. 

2024-04-09_09-46-28.png

TobiasFitschen
8 - Asteroid
Spoiler
Challenge_421.png

MitchyMitch
8 - Asteroid

Good challenge! Feel like I'm getting more efficient as I go! 😊

Spoiler
Challenge 421.png
Powerhouse_21
9 - Comet
Spoiler
421.png

421-map.png

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Cool challenge :)

 

Spoiler
421.PNG

 

 

TurboToad
10 - Fireball

Took a minute to figure out the spatial tools & map, fun challenge! ☀️😎

Spoiler
421.PNG

AkimasaKajitani
17 - Castor
17 - Castor

My solution! Fun challenge!! @gawa -san!

 

I found that the start input has a problem that doesn't contain the whole original input files.

 

Spoiler

Start file input
スクリーンショット 2024-04-10 233853.png

Original File
スクリーンショット 2024-04-10 235058.png


This file contained an unnecessary comma at the end of the file, which caused a conversion error.


When I use the original files, I can get 48 cities at task 1(sample output is 41 cities).

 

Workflow

 

Spoiler
スクリーンショット 2024-04-10 234220.png

スクリーンショット 2024-04-10 234539.png



 

 

ARussell34
8 - Asteroid

I probably could have started with a union to just pull in both files...hindsight is 20/20.

 

AR_421.png