Challenge #1: Join to Range

[adriantanjy]

It was an enjoyable experience solving this challenge!

[oswinhull]

Trying to work through these to prepare for the certification test. Never used multi row tool before but its pretty cool.

[brandnewday]

This challenge was fun)

By the way, are you sure it's intermediate level and not beginner?

Spoiler

Challenge 1 Solution

[Suzu]

Here is my solution.

[roblen]

It's a nice refresher because I rarely use Generate Rows tool.

[lcrutch001]

Spoiler

[Hary]

I enjoyed this challenge!

I've never use"generate row tool" and "text to columns" , so tried to solve by fomula and filter tool.

(I'll try both)

Spoiler

[WillTravelForData]

My solution is attached.

[mrao]

Hi,

Another solution could be generate the postal code range for each data row, then join and summarize. 

We don't need to generate rows and/or append fields.. 

Regards,

[datamonkey]

I realised after looking at the solution that I should have just used text to columns as my solution depends on the postcode always being four digits... :-/