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.
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.
alteryx Community

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #1: Join to Range

Alteryx

Challenge number one - and coincidentally the same solution step as this weeks challenge!

Spoiler
5 - Atom

Here's what my solution looks like:

Spoiler

8 - Asteroid

Are there any more efficient generalized solutions to doing this?

Append Fields : this is the method I would typically use, but say your list has 100,000 ranges in it. Do you really want to cartesian product 100,000x your rows?

Generate Rows : say the ranges are 1,000,000 numbers wide. And your values could be 10 digit decimals - you don't want to have to generate a row for every possible number between 0 and 1,000,000 in order to then do a simple join.

Formula Tool : on its own this doesn't seem generalizable, you have to code the formula and each range by hand. So if you have 1000 ranges, you'll be typing for awhile.

Tile Tool : you have to know and type in each range bound, so again it's manual and if you have 100,000 ranges in it you're going to have a bad time. It doesn't seem that you can dynamically tile based on another value

Let's say you have a list of 10 million customers, and you want to assign some value based on their income. But you have 10,000 potential ranges you want to assign, and they aren't all equal (i.e. not all 1000 dollars apart). What would you do to have a clean, fast, efficient workflow?

7 - Meteor
Spoiler

Back to first, have fun!

5 - Atom

This is my first post to the weekly challenge. Challenge accepted!

5 - Atom

Back to basics. Enjoyed this one!

8 - Asteroid

My Solution

Alteryx

Have to start somewhere, might as well be at the beginning. First dive into the pool - excited to grow my skills. This is a great way to learn!

Spencer Hong
Competitive Intelligence Analyst, Product Management
Alteryx
8 - Asteroid
Spoiler

Alteryx

My solution:

Spoiler