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

here we go:

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

My solution.

This was a fun challenge, thank you @gawa!

And a great practice for spatial tools.

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

Challenge 421.png

Cool challenge :)

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

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

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

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

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

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

スクリーンショット 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).

Start file inputOriginal FileThis 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

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

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

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