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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #1: Join to Range

Late to this party. I haven't used the generate rows tool before so this was a good exercise!

Highlighted
Alteryx
Alteryx

Here my approach:

 

Spoiler
Spoiler ahead:

Challenge 1.png
Meteor
Spoiler
1.PNG
Asteroid

 Working through a handful of these in preparation for Inspire!

 

 

Atom

Not necessarily the most computationally efficient way to do it, but easier to read IMHO.

Append all possible options and filter as appropriate, then sum. I've added a test to ensure full mapping.

 

Meteor

Here's my attempt

Atom

Love the "real" solution as it' can be generalized. Here was my first attempt, which is rigid, but gets the job done.

Alteryx Partner
Spoiler
Challenge 1.PNG
Alteryx Partner

Here's my solution. I didn't use the join tool as suggested by the challenge's title "Join to range" but the find replace tool instead. All roads lead to Rome.

Meteor