Fuzzy Dictionary Mapping

Compares strings in a given column to values in a given dictionary and appends the best (fuzzy) matching dictionary entry. This can be helpful to transform random, possibly misspelled and heterogene input values to uniform output values. This is the generalized form of the "Country Code Mapping" component.

Options

Lookup Columns

Select the (string) columns to lookup words from. These will all be taken into account and the closest fuzzy matching string will be appended to the input table.

Appended Columns

Select the columns of your input dictionary whose closest matches will be appended to the input table.

Values to match

The column containing the values to which an fuzzy matched dictionary entry is to be attached.

Nodes

• RowID3 ×
• String Manipulation3 ×
• Column Filter Configuration2 ×
• Column Rename2 ×
• Column Filter1 ×
• Show all 17 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Distance Matrix
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available