Challenge #346: Map Messi and Ronaldo's Goals (Part 1)

[rohityaman]

Solved!

Spoiler

[alineruizcampos]

Spoiler

 

[AndreeaS]

Spoiler

[Tgigs]

My solution attached.

Here are the steps I took.

1) Cleaned up the JSON_Name column using regex to remove the leading digits.

2) Used find and replace with unicode conversion table to clean up JSON_ValueString column.

3) Used make columns tool with dyanamic select and rename to restructure the data.

4) Joined the datasets into one dataset based on wyId and playerId fields.

5) Filtered by shortName contains "Messi" or shortName contains "Ronaldo"

Nice little dynamic way to restructure the data. Never used the make columns tool before. Also was nice to get to use the find and replace tool. Used some new tools for this exercise so it was beneficial.

[Carolyn]

Solved!

Spoiler

 

[tristank]

GOOOOOOOOOOOOOAAAAAAAAAAAAAAAAAAAAAAAAALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL

Spoiler

[jacobcarman]

Spoiler

My solution for part 1.

[mithily]

Spoiler

ok one more to go for today

[DaisukeTsuchiya]

Spoiler

 

[Rana_Kareem]

Spoiler