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

6 - Meteoroid

My solution to challenge 1 

Alteryx Partner

Challenge 1 Complete

6 - Meteoroid

Capture.PNGHere is my solution: 

Used Select Records, Generate Rows, Union, Join and Summarize Tools to get the desired results.

8 - Asteroid

Here's my solution using the Formula tool.

 

Spoiler
p-g_0-1605676410744.png

 

7 - Meteor
Spoiler
#1.JPG
8 - Asteroid
Spoiler
workflow.png
Alteryx Certified Partner

Nice use of Generate Rows (although it took a while to configure admittedly haha)!

Alteryx Certified Partner
Alteryx Certified Partner

Going back through the weekly challenges and starting from scratch. I chose to use the Advanced Join for this one to make it easier to establish a relationship for which regional rep the customer belonged to. By using the cross join I was able to accomplish the resilts in less steps because it works like a conditional join. 

 

Spoiler

Solution:

Snag_b1f32d0.png

[Postal1]<=[Postal Area] AND [Postal Area]<=[Postal2]

Snag_b1dae62.png

 

Alteryx Partner

Here is my solution!

 

5 - Atom

my solution is to use the formula function