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 #1: Join to Range

Alteryx Partner
 
Alteryx Partner
Spoiler
Capture.PNG
Meteoroid

~Joren

Alteryx Certified Partner

Late to the game, but here it is.

Alteryx Certified Partner

Good challenge to get started with. I used a formula after appending the fields instead of doing it the generate rows way but I'll now try it that way too as it's all about building knowledge!

Alteryx Partner

This is my first post and first completed Challenge. Figured, why not start at numero uno!

 

Question:

Is the completion of old challenges counted toward the hiker thing or counts that I see that are going on...?

OR

Do I need to complete them within that week time frame...?

 

Pretty sure that I have completed the task successfully...

  1. I created a new column in the Customer Record data set called region with a conditional expression.
  2. Joined that with the Sales Rep data (on new Sales Region Code)
    1. Right in the join I removed the fields/records that I did not need and then...
  3. Summarized

Is there a specific reason that the longer route in the solution was taken that maybe I am missing...?

 

Sr. Instructional Designer
Sr. Instructional Designer

@Syfer889  Glad you have you join us for the Weekly Challenge!  A Challenge, no matter when it is completed, counts toward earning the Weekly Challenge badges.  Good luck, and have fun out there!

Highlighted
Alteryx Partner
Spoiler

image.png

 OK my third Challenge - in 2018  I'm planning to go through all challenges - here goes the first one :) As long as I'll be doing more than one per week I'm gonna finally catch up :)

Alteryx Partner

Kudos to that, I am with you Ukashi! Hoping to get 3 done per week 2 historic challenges and the current weeks challenge, to catch up!

Alteryx Partner

Thank you!

 

Nice to hear  that! I'll keep my fingers crossed for you!

Your post motivates me to try to do more than 2 as well :)