General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Is there a way to create a "fuzzy" relationship between tables?
For example, the key field in a table might be a person's full name (first and last names with optional middle name or initial). The key field in another table might be last name and first name. Is there a way to create a relationship on these fields and have Power Pivot correctly determine that "John Q. Public" matches to "Public, John"?
For example, the key field in a table might be a person's full name (first and last names with optional middle name or initial). The key field in another table might be last name and first name. Is there a way to create a relationship on these fields and have Power Pivot correctly determine that "John Q. Public" matches to "Public, John"?