You’re offline. This is a read only version of the page.
4
Hello,
I have the following challenge:
I have a list of contract line items:
| Contact ID | Line item ID | Description |
| 10001 | 10 | Item A |
| 10001 | 20 | Item B |
| 10001 | 30 | Item C |
| 10002 | 10 | Item D |
| 10002 | 20 | Item A |
| 10003 | 10 | Item A |
| 10003 | 20 | Item B |
| 10003 | 30 | Item D |
| 10003 | 40 | Item E |
| 10004 | 10 | Item F |
I would like to identify for each Contract ID which other contract have an overlap of line item Description of more than 49%.
So the expected out come should be the following:
| Base Contract ID | Comparison Contract ID | Percent Overlap |
| 10001 | 10003 | 66.6 |
| 10002 | 10001 | 50.0 |
| 10002 | 10003 | 100.0 |
| 10003 | 10001 | 50.0 |
| 10003 | 10002 | 50.0 |
I hope that something like this is possible with M code and would appreciate any advice.
Thank You.
Hello,
update to this post...
Solution has been provided by a post available here:
Thanks again to @AlienSx.
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
