# Finding duplicates compagnies **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [January 28, 2020, 2:42pm UTC](https://forum.knime.com/t/finding-duplicates-compagnies/20704 "2020-01-28T14:42:55Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [January 29, 2020, 5:06am UTC](https://forum.knime.com/t/finding-duplicates-compagnies/20704/5 "2020-01-29T05:06:52Z")
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](https://forum.knime.com/t/rule-based-filter-question/13419/7): > > 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?](https://forum.knime.com/t/how-to-read-multiple-excel-files-in-one-folder/9775/17): > > 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](https://forum.knime.com/t/calculate-the-similarity-of-two-value-string/9939/2) 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](https://www.knime.com/knime-applications/address-deduplication) Also if you just want to calculate the similarity of strings there is this thread: --- _[View the full topic](https://forum.knime.com/t/finding-duplicates-compagnies/20704)._