alteryx Community

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.

Challenge #421: Which US city could observe solar eclipses in both 2023 and 2024?

Alteryx

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).

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:

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

Good luck!

16 - Nebula

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

16 - Nebula

Nice challenge!

Spoiler
11 - Bolide

C421. Updated solution to find city overlap

Spoiler

8 - Asteroid

8 - Asteroid
Spoiler
Solution Attached

13 - Pulsar

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

5 - Atom

Kerrville, Texas

16 - Nebula
Spoiler
16 - Nebula
Spoiler