I am attempting to match up two datasets with country columns - these two datasets come from different sources and therefore have slightly different strings for countries (e.g. ‘United States’ vs ‘United States of America’). I would like to know if there is some kind of fuzzy match workflow integrated into knime to match up the similar columns and then from there rename all the columns in one table to match the other.
As someone fairly new to knime any help would be very appreciated!