Challenge #1: Join to Range

[Tomasch]

my solution

Spoiler

[Prabudh28]

Done!!#1

[cwkoops]

Good use case for the MOD function.  

[EFos]

Spoiler

[DanTh]

Not the ideal solution, as doesn't adapt well to new postal ranges. I took the Multi-Field Binning tool to create five intervals, which I could then join to the ranges by adding a Record ID tool.

3/5

[harrietowen30]

Spoiler

Spoiler

Realised I probably did this in a very inefficient way...especially for different use cases where there are millions of rows within the dataset. So was good to view the solution afterwards but got the same result!

[Harrylosborne]

Spoiler

Good to know more about Generate Rows to fill in the gaps between ranges.

[AliAgah]

Spoiler

First time using Generate Rows. Amazing how much harder these challenges are when you don't know the existence of a tool.

[FredNajjar]

Spoiler

[JoaoLeiteV]

Starting those weekly challenges! Used Regex for parsing the range, but couldn't escape the generate rows haha

Spoiler