Weekly Challenge

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

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

Submit Feedback
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.

Challenge #1: Join to Range

Highlighted
8 - Asteroid

Solution:

Highlighted
Alteryx Certified Partner

My solution.

 

Spoiler
AkimasaKajitani_0-1600768330580.png

 

Highlighted
Alteryx Partner

Here's my solution, it isn't particularly scalable. I'd definitely use generate rows in future for similar problems.

Spoiler
Challenge 1.jpg
Highlighted
7 - Meteor

Used generate rows. Soon after finishing realized there is a more elegant solution. Still here is my initial one.

 

solution_1.PNG

 

 

Highlighted
5 - Atom

This seems a more efficient solution (probably someone else also has done it this way)

Evlieg_0-1600897649083.png

 

Highlighted
7 - Meteor

PFA

Highlighted
5 - Atom

Thanks @Evlieg, this was an interesting solution you shared. However, I consider the Generate Rows method as more efficient. Since the Append tool does a Cartesian product, it generates a larger number of records (if we apply this approach to larger databases, you can understand the costs). Using the Generate Rows tool, you can limit the rows generated to as many records as the original one. I hope this made sense. I still learnt a new approach from you. I, on the other hand, am quite embarassed to say my first thoughts were to use conditionals (so pedestrian, I know!) but quit since it's not scalable and in the process, learnt about Generate Rows tool!

 

 

 

 

Highlighted
6 - Meteoroid

Here is my solution.

 

JoeBarndollar_0-1601071374595.png

 

Highlighted
8 - Asteroid

This was an easy one to start with.

Highlighted
6 - Meteoroid

Here is the solution that I navigated through. Truly there are many ways to get to same solution.