top of page
Ed Orlando
Data Scientist | White Lodging
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.
Data Set #1 Data Set #2
Alteryx Weekly Challenge #1
Join to Range
https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037


Workflow with Detail




Final Data Set Solution




bottom of page