Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
anf1sher
Frequent Visitor

"Loose string matching" in two columns

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?

4 REPLIES 4
Phil_Seamark
Employee
Employee

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

I'm not sure I understand what you're asking.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.