SOLVED
Comparing Records between two fields
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
nfoong
7 - Meteor
‎07-05-2017
07:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have the following sample and would like to convert it to the next table below, which shows that if the 2 routes have the same supplier, show the number of common suppliers between both routes. Hope that makes sense.
Thanks.
Supplier | Routes |
A | Route 1 |
B | Route 2 |
B | Route 3 |
C | Route 2 |
C | Route 3 |
D | Route 4 |
E | Route 1 |
Route 1 | Route 2 | Route 3 | Route 4 | |
Route 1 | x | |||
Route 2 | x | 1 | ||
Route 3 | 1 | x | ||
Route 4 | x |
Solved! Go to Solution.
Labels:
- Labels:
- Predictive Analysis
- Preparation
2 REPLIES 2
Joe_Mako
12 - Quasar
‎07-05-2017
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
skalgaonkar
6 - Meteoroid
‎04-23-2020
07:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I realize this is a few years later, but I was recently looking to resolve a similar issue and your solution helped. Thank you!
