I didn't get a chance to consider International reputation but I got to use RegEx for the first time (successfully) to parse out numbers and separate the headers from the scores in the Rating Coefficients for the second part of the challenge. This dataset is very interesting and I hope to use Tableau to make some visualizations with it.
I'm neither a fan of soccer/football nor sports video games, so this was all pretty much gibberish to me at first (Goalkeeper vs. Sweeper?) In the end, it was just a parsing and reshaping exercise!
Spoiler
First, I made a lookup table with the expected output and associated position names:
Step 2: transpose player and attribute data by player ID and position:
Step 3: join player scores to attribute coefficients and calculate the total score
Step 4: format the output table (I know this is overkill, but for some reason, I really dislike manually renaming/ordering lots columns in the Select tool! Also, in a production environment, this would allow for rearranging/renaming the output columns without having to adjust tools.)
Finally, recreating the attribute table:
Also, the only places where my solution does not match the provided solution is when players or teams have special characters in their names. The input player data has ? instead of special characters, while the solution table includes the special characters.
Step 2: transpose player and attribute data by player ID and position:
Step 3: join player scores to attribute coefficients and calculate the total score
Step 4: format the output table (I know this is overkill, but for some reason, I really dislike manually renaming/ordering lots columns in the Select tool! Also, in a production environment, this would allow for rearranging/renaming the output columns without having to adjust tools.)
Finally, recreating the attribute table:
Also, the only places where my solution does not match the provided solution is when players or teams have special characters in their names. The input player data has ? instead of special characters, while the solution table includes the special characters.
My solution!
Spoiler
I opted for the tougher challenge on this one, and might not have interpreted the rules correctly (I didn't really compare to the final output since I figured there would be differences)... but I felt like it was at least a semi-logical approach, and the numbers looked reasonable, so I just went with it :)
Couple things to call out: I noticed there were some skills/attributes in the FIFA player data that were not in the Ratings Coefficients data, so a few attributes were left out of my calculations. I also had to make some assumptions about what the "OVR" field was used for in comparison to the "Increase" field for the skills in the International Reputation table... I landed on (Value (of player skill) + Increase) * Coefficient), then summarized points by Position, then added OVR if present to the final position score. No idea if that is the correct formula, but the instructions were vague enough on that point that I figured it wouldn't make much of a difference.
Couple things to call out: I noticed there were some skills/attributes in the FIFA player data that were not in the Ratings Coefficients data, so a few attributes were left out of my calculations. I also had to make some assumptions about what the "OVR" field was used for in comparison to the "Increase" field for the skills in the International Reputation table... I landed on (Value (of player skill) + Increase) * Coefficient), then summarized points by Position, then added OVR if present to the final position score. No idea if that is the correct formula, but the instructions were vague enough on that point that I figured it wouldn't make much of a difference.
Cheers,
NJ
I unfortunately had 
