Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi experts,
I have two columns containing list of different names and these two columns are in two different tables. I would like to compare these columns and find out all the matching words or If some parts of the words are matching in both the lists for example - Georgers SRL or SRL Georgers or Georgers.
Strings containing 3 words, If only one word is matching with the word of other list, then also Its fine. Basically idea is to match two columns and find all the identical words/ parts of word .
I hope you got my point.
Thanks in advance.
Best Regards,
Diksha
Solved! Go to Solution.
Hi,
Try the Fuzzy Lookup feature of the Query Editor.
Hi,
Share some data and show the expected result. Please ensure that the sample data that you share should be representative of your actual data.
Hi Ashish,
Thank you for replying.
Data would be somewhat like this. It can be a large dataset instead but this will be the type. If you could please help me to create a query, It would be really helpful.We need to match all the words and If some words contains its parts, then also we want it to be displayed as match.
Hi,
You have still not shown the expected result.
Hi,
Sorry, I'm mentioning it below for your reference.
Hi,
Try the Fuzzy Lookup feature of the Query Editor.
Hi Ashish,
Thank you for introducing me to the Fuzzy Matching feature. I tried it but It worked partially.
This is the table which I wanted to match and I wanted to display GUPTA in front of DIKSHA GUPTA as well but It did not happen.
The below attached image was my result
So you can see that GUPTA is not displayed. Why is It like that?
What do I need to do for that.
Thank you
Best Regards,
Diksha
Hi,
Adjust the similarity threshold. Please read this - Create a fuzzy match (Power Query).
Hi @Anonymous ,
You can create a query like this:
let
tb1 = Table.ExpandListColumn(Table.TransformColumns(#"Table 1", {{"Name", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Name"),
tb2 = #"Table 2",
tb = List.Intersect({tb1[Name],tb2[Name]}),
#"Converted to Table" = Table.FromList(tb, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |