Similarity Tool Unable to identify tab 1 data

[praveenrajp]

[MartinDDDD]

I’m really sorry, does not get any more unclear what you need help with - there’s not even the error message shown in your screenshot.

If you want to enhance your chances of getting help here I strongly recommend to read (and follow) this guidance:

How to Best Ask For Help on the Forum

How to Best Ask for Help Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: How can you write a post that is most likely to get the help you need? You might think that logically, a good title for your post would be “Help with an error”, right? Well… not exactly. Put yourself …

[praveenrajp]

Error :-The input tables have no columns in common; consider to rename corresponding columns

and when i keep columns with same name I’m able to see both columns but still unable to execute similarity search

Getting below error :-Execute failed: Argument contains duplicates: [Legal Entity Name, Legal Entity Name]

Goal is to compare legal name in tab1 and tab 2 and get 95-100 match

[mlauber71]

@praveenrajp you could take a look at this example:

KNIME Community Hub

If you do not have any ground truth you can try this approach:

Fuzzy match rows in one column

@robvp I once created this workflow that would group addresses without a ground truth against which to match. Maybe you can adapt that. If you apply this it looks something like this: [image] You can edit the threshold which would constitute a similarity (Similarity Search – KNIME Community Hub) and maybe also configure the method. [image] If you set the threshold to 0.33 (instead of 0.25) the result would be this: [image] What you could do would be to try change the order of the wor…