Challenge #1: Join to Range

[dpencheva]

Hi 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.

[harii8]

A little late, but thought I'll start now.

[olsun]

Spoiler

I came up with 2 possible solutions:

• Append and Filter

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 and Join

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.

[samahmed28]

Solved

[hayley9]

Here is my solution

[rohanonline]

Here's my solution.

[Gopinaath]

Here is my solution

[SahinC]

Spoiler

My solution