Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #156: What Position Should You Play?

Highlighted
8 - Asteroid
Spoiler
Fun one image.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution

Highlighted
Alteryx Certified 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

Highlighted
7 - 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!

 

 

 

Highlighted
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
Highlighted
5 - Atom

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

Highlighted
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
Challange 156 easy part.Challange 156 easy part.
Highlighted
8 - Asteroid

my solution

Highlighted
Alteryx Certified 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
Attribute preparationAttribute 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
Player calculationPlayer 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

 

 

 

 

Highlighted
11 - Bolide
Spoiler
Challenge_156_ka_screenshot.PNG