Challenge #1: Join to Range

[Erlina]

Here's my solution

Spoiler

[Kiwi_Li]

Here is my solution for challenge 1!

Spoiler

[lyon_abido]

Fun challenge!

[KorkuSep]

Hello. 

Doing this challenge taught me on using the importance of generate row tool to create rows for a join task.

Spoiler

[LucaCapaldi]

Super fun Challenge!

[SrikanthSoma]

Thanks for a nice challenge. I learnt two new tools today. 

Spoiler

I did not know about the  Text to Columns tool. I used TONUMBER(LEFT([Range],4)),TONUMBER(Right([Range],4)) (int datatype) to create RangeStart, RangeEnd columns and then used the Generate Rows tool to create PostalCode column. I initated with RangeStart, condition was PostalCode <= RangeEnd, loop has a increment of 1 to PostalCode.

[daiphuongngo]

Completed

[daiphuongngo]

Spoiler

 

[ShankerV]

Good one my dear friend, done without even splitting into 2 rows

[ShankerV]

Good one, where both output are joined and then checked for Zero's in Left join and Right join was excellent