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

Atom

Attached is my solution. I'm fairly new to Alteryx so I tried on my own then followed the solution step by step to learn the new tools.

Atom

I'm new to the community and the software.

 

Try my best to catch up and learn as fast as I can.

Hi,

 

New to solving the challenges. But great fun

Alteryx Certified Partner

My solution with a data validation piece at the end


Annotation 2019-07-28 205329.png

Atom

Hi Kacper,

 

Just started Altreryx, 

 

Did the same thing as you because I didn't know that the tool "Generate rows" existed.

 

I think this solution is a bit more data intensive, from the one proposed, because from 2678 rows we go to 13390 in order to pose the filter formula and separate out the data. On the other hand, the "Generate rows" way create less: 5-->20 rows and then the join tool does all the rest. I am not an expert but there is something to think about.

 

If there were a lot more postal ranges and the ranges were bigger then I think the generate rows would be also expensive.

 

Liked the test part.  Nice work.

 

Nikos

Alteryx Partner
Spoiler
Spoiler

Challenge 64.JPG

Meteor

Here's my solution to this one. Thanks, Will

 
Meteor

Hello! Here is my solution for good ol' #1.

Spoiler
challenge-001.PNG
Asteroid

All the way back to number 1, let's see how long the momentum holds...