Challenge #321: Eurovision

[CHADD]

PFA 

[maggiexylin]

Please see attached.

[acmarv]

Here's my solution...

[LuisCarreyo]

A few observations I found interesting while doing the challenge (spoilers if you want to solve this on your own):

Spoiler

1. For 1991, I looked up and found out that Sweden was the winner.

2. I thought using the Summarize tool once could solve the problem of finding the winner per year, but eventually had to use it two times in a row. First I had to make a sum of the points by edition and by country, and then look for the max by country. Also, the joining keys were crucial to have accurate outputs.

3. There were multiple ways I thought about filtering the Edition field, but eventually found easier equaling to zero those records that gave points to their representative. My alternative solution was creating a new field that had the countries that gave points to their representative and delete those records, but it was too much work for a simple task.

[leebrittany]

attached

[Amayas]

C321

[Mikeimbi]

Solution with batch

[geoche]

My answer for this challenge. There is a small mistake in a the output dataset, the winner of the 1991 edition is Sweden not France.

Spoiler

[nikhil_jaju]

Solution

[snbandi]

My solution in preparation for Alteryx Foundation Micro-Credential Exam. Solved all of the Weekly Challenges from "Alteryx Foundation Micro-Credential Exam Prep Guide". Loading all of them together.