A company in Australia has source data which is made up of a series of postal codes (eg. 2000, 2001, 2002 etc.) amongst some other data fields.
They have a separate reference table which contains postcode ranges (eg. 2000 to 2002) which they would like to use to match/filter their main data.
Each Customer Record needs to be joined to the Lookup table based on a Postal Area Ranged region.
Then finally summarize the customer data by Region, Sales Rep, and Responder, then a count of customers.
Here is the weekly challenge link in the Alteryx community: Challenge #1: Join to Range
This challenge covers the following concepts:
- Data Preparation
The Alteryx tools and techniques that can be used to solve this challenge are as follows:
- Prepare
- Join
- Parse
- Transform
The proficiency level required to solve the challenge is : Intermediate
Here is the snippet of the workflow that achieves the required result:
