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

[sophiezero]

A fun challenge, the tricky part:

1. If you unique on the city name, it will give you two answers that is not correct, the lat/long for Farmington is not the same.

2. The sequence of dots is based on t_5, who would know?

Spoiler

[nli]

Great way to explore the Report Map tool!

[Brando]

There's a data cleanliness problem with the key for task 1, and I'm terrible at the mapping tool. I can't get my output to look as beautiful as the key for task 2. Also, I'm willing to admit I'm wrong here but there are two cities that have both eclipses, not just one.

[Dev73]

Spatial challenges is love 😊

Spoiler

[Ray_Pospisil]

only Alteryx today

[sknman92]

Spoiler

got to practice regex (completely forgot about json parse), spatial, and reporting. good exercise!

[vizwithdan]

This was a toughie! First part fairly easy, second part a different story.....but it helped me learn a lot about spatial tools and the reporting map tool! WIN! 

[dorinnaP]

Spoiler

Used text to columns and trimming characters instead of JSON parse for this one. Took me a while to realise there were two cities with the same name

[CandiceDB]

My solution 😊:

Spoiler

[lynnesonneyrsm]

My solution is attached!