Good Morning Team,
Looking for some help,
Trying to create some logic to identify duplicates identifiers (Column D) based on a combination of 3 Columns
I have created the following matrix that hopefully articulates the problem
internal ID | Privacy | Identifier | Duplicate | Scenario |
MASOCE6GnHH63gvL8qFeL | Public | 11111 | Yes | 1 |
MASOCE6GnHH63gvL8qFeL | Public | 11111 | ||
MASOCE6GnHH63gvL8qFeL | Public | 11111 | No | 1 |
MASOCE6GnHH63gvL8qFeL | Private | 11111 | ||
CDMCE6GnHH63gvL8qFeL | Private | 11111 | No | 1 |
CDMCE6GnHH63gvL8qFeL | Private | 11111 | ||
MASOC7xsHXZubkvfWlNf0 | Public | 11111 | Yes | 2 |
MASOCLEPKXEZVJHAQhlxs | Public | 11111 | ||
MASOC7xsHXZubkvfWlNf0 | Public | 11111 | Yes | 2 |
MASOCLEPKXEZVJHAQhlxs | Private | 11111 | ||
MASOC7xsHXZubkvfWlNf0 | Private | 11111 | Yes | 2 |
MASOCLEPKXEZVJHAQhlxs | Private | 11111 |
use the unique tool and select the relevant fields would that work?