Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #1: Join to Range


This is a super creative solution @MarvinPinto. I enjoyed looking at it.


Hi Denise,


Your approach didn't seem that "fairly new". That was a pretty outside the box approach; I like how you use a Cartesian product by appending the two tables together and filter the data again, creating a cross join basically.


That was very creative @DEO413 


On this solution, I use the same Advanced Join tool previously referenced by @AndrewDataKim The tool makes it really easy to create a custom cross join that reminds me of a cross join I have used in the past with Power Query.


Thanks to @JoeM for guiding me to the advanced join link.!app/Advanced-Join/547f8df96ac90f0f2ca5e439


Alteryx Partner

Challenge 1 complete!




This was quick.


Completed! I used Tile, though...


Hello @ADerbak


I like your approach to solving this problem; by manually setting the maximum limit of the Tile Cutoffs, you are basically getting a unique value for the Tile Num that you can use on the following join with the Tile Num generated by the unique value of the Range.


I thought I was going to be concerned with the sorting order of the first table of the range values, but the unique value tile tool automatically assigns the lowest tile num to the lowest range values; so even if this table wasn't sorted, the unique value tile tool would assign the correct tile num to match.


Thus, very solid approach.


Thanks, JORGE4900!


Think I've got a lot of catching up to do...


Learned a lot.  I knew how to do this in Access but was stumped in Alteryx.  The generate rows tool is really neat.  Thank you.