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.

Challenge #122: Think Like a CSE...Ranking Data

Quasar
Spoiler
Seems to be the most common approach :)

Challenge #122.PNG
Asteroid

This was quick and simple. 

 

PS: Can someone let me know where to find the macro for checking the output - I see some members have used it to validate output.

Meteor

Similar solution as others have posted - two tools and expect equal to check.

@AGoyal It's part of the CReW macros over here

Meteor

Got to use a tool that I just learned over the weekend :)

 

Spoiler
challenge_122_jackie.JPG
Asteroid

Here is my solution:

Spoiler
workflow 122.JPG

 EDIT : I see my solution is longer than most, at least it's different. ;)

Alteryx Certified Partner

Solution attached. Similar to challenge #9, but with the more common ranking methodology.

Meteor

Here is my solution quick and easy.

Asteroid

Here's my solution

 

Spoiler
Always forget you can rename the Record ID field in the initial tool!

Challenge 122.jpg

 

 

 

Alteryx Partner

Looks like the standard solution

Spoiler
cse workflow.JPG