Challenge #1: Join to Range
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
akhansen246
5 - Atom
08-31-2023
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
InchulKo
7 - Meteor
08-31-2023
07:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Gem
9 - Comet
09-01-2023
03:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
EricL0399
7 - Meteor
09-06-2023
05:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My challenge Solution:
Spoiler
Split the ranges of postal codes into two columns, parsing on the hyphen. Use a Generate rows tool to create a row for each postal code using the Lower Range [PostStart] and Upper Range [PostEnd] numbers as counting limits within the formula. Join the data set on the postal codes, so now each customer ID has The Region and Rep associated with it. Did not include the Expected Revenue at this point in the flow because it didn't feel relevant/usable in the join. Quick Summary and done.
Generate Rows formula: [PostalCode] = [PostStart]; while PostalCode <= [PostEnd]; [PostalCode] + 1
Generate Rows formula: [PostalCode] = [PostStart]; while PostalCode <= [PostEnd]; [PostalCode] + 1
revenkatesh
5 - Atom
09-10-2023
10:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
MDestra
8 - Asteroid
09-11-2023
09:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
EnglishmaninNY
8 - Asteroid
09-14-2023
11:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I used what I call an "open join" but I see now that append tool basically does the same thing and is better way to go. I was unfamiliar with the Generate rows tool and that is more elegant to me as it avoids generating so many rows. Thanks
orangebomber
7 - Meteor
09-17-2023
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
williamnolan03
8 - Asteroid
09-18-2023
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jokern
5 - Atom
09-18-2023
06:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator