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

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

 

Hi Maveryx,

 

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

 

This challenge was submitted by our ACE and an active member in the Alteryx Community, Ippei Nakagawa (@gawa)  . Thank you Gawa for your contribution and we look forward to the next ones that you may bring to the table!

 

Across the United States, an annular solar eclipse was observed on October 14, 2023, and a total solar eclipse will be observed on April 8, 2024. In this challenge, you will determine which lucky cities in the USA observed an annular solar eclipse in 2023 and which ones will observe the total solar eclipse in 2024, as well as one lucky city that will observe both! The provided datasets include solar eclipse information from 2023 and 2024 including the name of the city; latitude and longitude of the city; how long the eclipse will last; and the eclipse’s category (P: partial, T: total, A: annual).

 

Your tasks:

  1. Create a combined list of the cities that observed the annular eclipse in 2023 and which cities will observe the total eclipse in 2024.
  2. Create a map to visualize each eclipse’s path throughout the year for 2023 and 2024.
  3. Determine the lucky city that will get to see both eclipses!

 

Hint: The provided datasets are JSON files. To facilitate the data extraction, use the Parse JSON tool in the Developer tab of Designer.

 

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

 

 

Sources: https://svs.gsfc.nasa.gov/
https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2023_city_times.json

https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2024_city_times.json

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Jean-Balteryx
16 - Nebula
16 - Nebula

Is there a problem with the headers in the first expected output ?

alexnajm
17 - Castor
17 - Castor

Nice challenge!

Spoiler
Challenge 421.png
mmontgomery
11 - Bolide
11 - Bolide

C421. Updated solution to find city overlap

Spoiler
421.png

 

danbostrom
8 - Asteroid

 

 

balajilolla2
9 - Comet
Spoiler
Solution Attached
 Screenshot 2024-04-08 082721.jpg
aatalai
14 - Magnetar

I got two answers for part 3, also for the remainders of the challenge I used the set after task 1 not sure if that was right 

Eddieinnc
5 - Atom

Kerrville, Texas

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
421.jpg