Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #1: Join to Range

abubakrsaad
5 - Atom

the idea is to use generate row tool

Peter-H
6 - Meteoroid
 
Stelz
5 - Atom

My solution

paulburrows
8 - Asteroid

Heres my solution thanks

vinalsn1
5 - Atom

Solution attached. Tricky one.

Sebenius
8 - Asteroid

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 1weekly 1
SueDonim
8 - Asteroid

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

MySolution.PNG
ademinaction
6 - Meteoroid

Please find my solution:

 

 

sgrabish1
8 - Asteroid

Easy to do with a guide available!  Good practice

kaianderson
8 - Asteroid