Finding duplicates compagnies

[mlauber71]

In addition to the workflow mentioned by @HansS and @Rich_ard (one created by @wiswedel ) you could check out these entries about the concept of

Fingerprinting

Rule Based Filter Question

The idea of fingerprinting in data is that if you do not have a unique ID you create your own from various features of your data. Classic example would be you have customers but no customer ID. You would take name, surname adress area code phone number … and combine them. You could do several variations like only using the first 5 characters of a name and ‘clean’ it by removing special characters or even using a phonetic extraction to counter various styles of writing. Or from an address you…

Compare strings and adresses

How to read multiple excel files in one folder?

First I think it would be best if you have a new question to open a new topic, makes it easier for people to find relevant information. Then as has been mentioned here there seems to be just the workflow you need to compare Adresses. Maybe you could adapt that: https://www.knime.com/knime-applications/address-deduplication Also if you just want to calculate the similarity of strings there is this thread: