community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #156: What Position Should You Play?

Meteor
Spoiler
Fun one image.png
Bolide

My solution

Alteryx Partner

Try and take a look at this post

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...

 

The Alteryx Package is basically a .zip file, so you could rename Weekly Challenge #156.yxzp to Weekly Challenge #156.zip and then just unpack the files.

 

The following guide above, you should be able to tweak the Weekly Challenge.yxmd and then be able to open the file in a older version.

 

Best of luck

Thomas

Meteor

My Solution and first post! 

In retrospect, I used a lot more selects than necessary. Hope this will be the first of many completed challenges!

 

 

 

Alteryx Partner

Looks like my answer follows pretty much what others have been posting. I only took the time to do the easy part.

 

Spoiler
I manually changed the attribute names to match between the two tables. Looking at other folks' answers, I could've been more elegant and used the find and replace tool.

Capture.PNG

MY Solution ------------------ Neymar

Alteryx Certified Partner

Forgot to upload it last week but found some small errors I had made so was good to go over it again.

 

Spoiler
156_Done_img.pngChallange 156 easy part.
Asteroid

my solution

Alteryx Partner

Challenges are normally of the type Beginner, Intermediate or Advanced, and this one was way to advance for me, even though it is labeled Intermediate

 

I have spent more than a day on this, and still not been able to match the provided output.

 

I could not figure out what to do with the International Reputation and Batch Chemistry, so I went for the semi-though challenge, and went to build the Attribute Reference from the Rating Coefficients.

 

Spoiler
2019-03-26 13_36_25-Alteryx Designer x64 - Weekly Challenge Solution_Verakso.yxmd_.pngAttribute preparationI did manage to match the provided Attribute Reference, but it took me a while to handle the logic about the shared attributes of Sweepers and Goalkeepers

 

Then I went for the calculation

Spoiler
2019-03-26 13_38_09-Alteryx Designer x64 - Weekly Challenge Solution_Verakso.yxmd_.pngPlayer calculation

 

Here I had pretty much from the beginning decided that I would like to use the Dynamic Replace tool, to do the calculation. I saw that in the Tool Mastery, and used in another previous challenge, so I thought it might be useful here

 

I cannot figure out it the reason to my result does not match the provided is because I have chosen the tools poorly, or simply cannot figure out how to do proper rounding of the numbers.

 

I also noticed that some of the players names does not match, and in the beginning I thought that it was some kind of “bug” in the transposes tool, so I did it all over again, just to figure out that the provided 2018 Fifa Player,csv file is in ANSI format, and therefore some of the players names are not the same in the source, as in the provided result.

 

I also spent some time, looking at some of the other provided solutions, just to find out, that I was not alone in this. None of the other provided solutions I have checked is a 100% match to the provided solution, so it should be interesting to see the “official” solution.

 

Still Climbing

/Thomas

 

 

 

 

Comet
Spoiler
Challenge_156_ka_screenshot.PNG