How to read multiple excel files in one folder?

[mlauber71]

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:

Deduplicate Address Data for Happier Customers | KNIME

https://www.knime.com/knime-applications/address-deduplication

Also if you just want to calculate the similarity of strings there is this thread:

Comparing Strings

Hello, I’m having problems doing something which I hope is quite simple. Ideally I would like to solve this without the need for any scripting. I’ve split a string up into a list of all the words that make that string (max 10). I then want to compare this list of words with those of another string using. I can do this in Excel easily - the first comparison yields a score of 2 and the second comparison yields a score of 3. In this instance I would choose the second comparison over the first one…