Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# Weekly Challenge

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 #204: Updating Brazil

Alteryx

A solution to last week’s challenge can be found here.image source: https://en.wikipedia.org/wiki/States_of_Brazil

Did you know that Brazil is the largest country in South America? “Super legal!” you say to yourself em Português. Brazil is also an incredibly diverse country with many unique geographic regions. That’s why it’s a good idea to bring a map.

Unfortunately, the map I found is from 1920 and doesn’t show all 27 states (26 and the Federal District). Your task is to use the supplied data to update the map from the 22 existing states to include all 27.

Additionally, the capital moved from Rio de Janeiro to Brasilia in 1960, so the updated state of Rio de Janeiro should regain the land occupied by the Federal District in the 1920 map.

Boa Sorte!

10 - Fireball
Spoiler

Not sure if purposeful but nice timing to reference Brazil with Carnaval going on right now!

Cheers from Rio de Janeiro!

11 - Bolide

Excelente desafio esta semana!

Spoiler
14 - Magnetar

My solution.  Probably a more efficient solution, but time is short this morning.

Spoiler

12 - Quasar

This is making me hungry for some pao de queijo!

Spoiler

Spoiler
Edit : 13:15 CST Added video walk through

8 - Asteroid

Here's my solution.

Step1: Process Federal District to merge with Rio

Step2: Remove parts of Old States that now belongs to New ones.

Step3: Combine all processed areas to generate final map.

Spoiler
Solution Screenshot
15 - Aurora

Here's my solution:

Spoiler
18 - Pollux

Spatial operations and functions for the win!!

Spoiler

Dan

16 - Nebula

I don't use spatial tools in my daily business, so it's usually a challenging task - but always interesting.

Spoiler
17 - Castor
Spoiler