Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi! What is the best way to compare a column of names with a column containing notes? If I were to just match names, I would build a relationship and use fuzzy match. However, since the second column contains sentences/paragraphs, fuzzy matching yields almost no results. Is there a best practice on how to do this? I'm thinking it involves a find/function and loop? Any help would be appreciated! Example columns are provided below.
Names |
Ashok Kumar |
Baby Doe |
Brett Boe |
Carla Coe |
Frank Foe |
Jackie Joe |
Jane Doe |
Jane Poe |
Jane Roe |
Joe Public |
John Doe |
Notes |
Jane Poe had a little lamb |
Jake was all business when he wore his clown suit. |
A quiet house is nice until you are ordered to stay in it for months. |
Writing a list of random sentences is harder than I initially thought it would be. |
Best friends are like old tomatoes and shoelaces. |
Seek success, but always be prepared for Joe Public. |
They improved dramatically once Frank Foe left. |
The small white buoys marked the location of hundreds of crab pots. |
Solved! Go to Solution.
Hi @Shiji ,
You can create a calculated column as below in Names table, please find the details in the attachment.
Notes =
CALCULATE (
MAX ( 'Notes'[Notes] ),
FILTER ( 'Notes', CONTAINSSTRING ( 'Notes'[Notes], 'Names'[Names] ) )
)
Best Regards
Hi @Shiji ,
You can create a calculated column as below in Names table, please find the details in the attachment.
Notes =
CALCULATE (
MAX ( 'Notes'[Notes] ),
FILTER ( 'Notes', CONTAINSSTRING ( 'Notes'[Notes], 'Names'[Names] ) )
)
Best Regards
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |