Column most likely match and return corresponding value

Dear Knimers,

If Column ‘A’ and Column ‘B’ most closer match then Column ‘C’ should be returned

Column ‘A’ Column ‘B’ Column ‘C’ Expected Knime Output
101 Manning Dr C Fl 2 101 MANNING DRIVE 27514 27514
101 Manning Dr C Fl 2 101 MANNING DRIVE 27514 27514
9200 W Wisconsin Ave 9200 WEST WISCONSIN AVENUE 53226 53226
9200 W Wisconsin Ave 9200 WEST WISC. AVENUE, FROEDTERT MEMORIAL LUTHERAN 53226 53226
195 Little Albany St 1 ROBERT WOOD JOHNSON PLACE 8901

Please share the node and Workflow it will be helpfull to me

I’d recommend working through the posts and workflows mentioned here: address deduplication, string similarity and fingerprinting (a collection) – KNIME Hub

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.