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 #210: Better Late Than Never

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found hereSource: https://tenor.com/search/along-came-polly-gifsSource: https://tenor.com/search/along-came-polly-gifs

 

The NBA is considered the world's premier basketball league; due in large part to the tremendously talented players who dazzle fans every time out on the court. One of the highest honors for any player is to be named an All-Star. All-Stars are selected each year to recognize outstanding performance at each position. The All-Stars 2000-2016 file contains a list of players named All-Stars over that time period.

 

You may notice that many of the league's 30 teams have at least one player selected over this time period. That is largely a result of the fact that regardless of whether they come from collegiate basketball teams or international club teams, players must enter the NBA Draft when entering the league. The draft is a system devised to spread talent across the league by giving teams who had poor seasons the best odds of signing the most promising new players coming into the league. In the current version of the draft, each of the 30 teams has one pick per round for 2 rounds. However, the league used to have fewer teams and more rounds in the draft. The Drafts Info file contains a listing of the number of picks in each round of the draft from 1984-2016.

 

For this week's challenge, find the 3 latest drafted players to play in an All-Star game between 2000-2016. (Undrafted players are ineligible; draft position is overall pick number in a given draft)

Highlighted
Alteryx Certified Partner

Man I miss the NBA! 

 

Spoiler
210.png
Spoiler
Edit : 10:08 CDT 2020-04-06 Added Video Link 

 

 

Highlighted
16 - Nebula
16 - Nebula
Spoiler
I couldn't resist using a little regex.

patrick_digan_0-1586182142410.png

 

Highlighted
Alteryx Partner

Fun and interesting challenge!

 

Spoiler
Capture v2.PNG 


Solution Video:

Spoiler
Highlighted
Alteryx Partner

Done, interesting one

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution.

 

Spoiler
210_workflow.png
Highlighted
Alteryx Certified Partner

Raindrops!

Spoiler
210.PNG
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Capture.PNG

Highlighted
7 - Meteor

Nice little run out

 

Spoiler
All Stars.PNG
Highlighted

Hello guys, below is my answer

 

mateuslucasxcrsilvei_0-1586188792665.png