Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.