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

Highlighted
Fireball

Generate Rows is a fantastic tool that I didn't discover until I'd been using Alteryx for several months. :-)

Asteroid
 
Highlighted
Meteor

Here is my answer to the challenge.  I'm sure there are more efficient ways of doing it (and I'll be sure to check out the generate rows feature!), but as a newbie, I'll take what I can get!

Highlighted

Very excited to work through these challenges and learning more about Alteryx!  Here is my solution before learning about the generate rows feature.

 

 

Highlighted
Meteor

Got it with a little help from my friends!  Posting my file for those interested. 

 

 

Highlighted
Meteor

Hello,

 

My solution attached. Checking against the solution posted it looks I've done pretty much the same thing. Good tip to rename new fields as i found leaving them as 1 and 2 a little confusing when writing the equation.

 

 Bring on Challenge #2!

Highlighted
Asteroid

Fresh from an Alteryx training session a few days ago (thank you @jamielaird), I thought I'd try these challenges. Let's see how far I can go.

 

Here's my solution to the first challenge. I went on replicating range string for each customer (via formula) and then summarising it before matching it with the range data. My solution needs to be modified to future proof it when the post code range changes, but at least it works for the current solution.

Highlighted
Meteor

Challenge #1 completed!  Moving forward!

Highlighted
Meteor

Challenge #1 completed :) 

Highlighted
Meteoroid