Matching rows of Datatables

[KB_Fleet (KB)]

Hi There,

I have successfully used the below code to compare comments in two datatables, however I’m hoping to include some sort of fuzzy matching, for example IF some part of row1 is contained in row2.

(From row1 In dtCommentList.AsEnumerable()
Join row2 In dtComments.AsEnumerable()
On row1("Comment").ToString() Equals row2("Comment").ToString() And row1("Comment").ToString() Equals row2("Comment").ToString()
Select row1).CopyToDataTable()

I have a DT of comments that I have to check exist in another DT, but the comment can vary and may not be an exact match, wondering if it would be possible to include a matching Regex, or containing inclusion in the code.

Many Thanks!

[adi.mehare (Aditya Mehare)]

You can use Semantic Similarity

AI Center - Semantic Similarity

Please check this video this might help you

How to measure String similarity in UiPath

[sven.wullum1]

Hi!

You could try to use some string-matching algorithms depending on how similar the comments are.
String Similarity Algorithms (Matching Percentage) - RPA Component | UiPath Marketplace | Overview