Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi this is my first post in the community and my first weekly challenge 🙂 I went through the solution but my idea is a little bit different. I wrote switch function, in Formula step, which contains ranges from the look up table and the result is a new column called Region.
I came up with 2 possible solutions:
Appends the Sales Person Area data to the Customer Postal data, then filters based on the Postal Area being within the Lower Postal and Upper Postal range.
Generate rows for each Postal Area within the Postal Range, then join to the Customer Postal data using Postal Area.
The quicker, and smaller memory footprint, is the Generate Rows and Join solution.
Attaching my Solution for sharing.
My solution