Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data from two different sources in a table and I want to do a "loose pattern match".
For example, data in the first column might be "Harvard University" and data in the other column might he "Harvard U".
I want the two columns to show as a match even though they are not identical.
Does that make sense?
Hi @anf1sher
There might be some R based functions that allow you to match as per your needs. Have you done anything similar in other tools/languages?
I've done something similar in Perl but I haven't seen any way to do this in Power BI.
Or would you be happy to match simply based on the sequence of characters from the shorter of the two?
I'm not sure I understand what you're asking.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |