Challenge #1: Join to Range

[mihaimazareanu]

Here is my solution.

Spoiler

 

[SidSaythongphet]

Spoiler

 

[nikhil_jaju]

Solution

[eolowohunwa]

My solution

[asultanov]

Fun!

[sidjainudr]

I have uploaded result which shows how to use generate rows which will make join very ease.

[snbandi]

Finished all suggested for Core preparation - and now starting with Starting from Challenges from the beginning.

[jdminton]

Spoiler

Spoiler

 

[albracht7]

Solution attached. 

Spoiler

Grouping Logic: 

IF [Postal Area] >= 2000 AND [Postal Area] <= 2019 then
"R1"
elseif [Postal Area] >= 2020 AND [Postal Area] <= 2039 then "R2"
elseif [Postal Area] >= 2040 AND [Postal Area] <= 2059 then "R3"
elseif [Postal Area] >= 2060 AND [Postal Area] <= 2079 then "R4"
elseif [Postal Area] >= 2080 AND [Postal Area] <= 2100 then "R5"
else
"unknown"
endif

Is there a better way to do this using the other reference table/"Look up table"? It felt like the long way around while I was typing it out. I appreciate any tips!

[bmerril6]

Spoiler

(From Range table) -> Text to Columns (separate out ranged years) -> Select (change recently created columns from String to Int)  -> Generate Rows (generate list of postal areas based on the start and end codes of the range) -> Join with Customer table based on Postal Area -> Summarize based on output requested