Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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:
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!
Is there a problem with the headers in the first expected output ?
Nice challenge!
Kerrville, Texas