Challenge #1: Join to Range

[abubakrsaad]

the idea is to use generate row tool

[Stelz]

My solution

[paulburrows]

Heres my solution thanks

[vinalsn1]

Solution attached. Tricky one.

[Sebenius]

Said at a user group I would do 100 challanges this year so the posting starts now I have had them done for quite some time but not posted:

Spoiler

weekly 1

[SueDonim]

Beat my head against the wall for a few on this, but it turned out to be quite simple once I got it sorted

Spoiler

Had struggled a little thinking I could not pull the source data through the initial summarisation tool, then realised I could just add GroupBy to grab the Region and Sales Rep data - Duh!  Simple after that.

Process:
- Text to columns to pull out the max and min post codes
- Select to rename fields (not really necessary)
- Summarise to determine the smallest and largest post codes in the table
- Generate rows from smallest to largest post code
- Join with customer, responder, and post code data
- GroupBY Sales Rep, Region, and Responder and Count of CustomerID

[ademinaction]

Please find my solution:

[sgrabish1]

Easy to do with a guide available!  Good practice