The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |