Icon

exorbyte_​Postcode_​Enrichment

This workflow shows a postal code enrichment to address data with an existing exorbyte MatchMaker index. Address data containing only street, house number, and city name is matched against the reference data containing postal codes in the MatchMaker index.

This workflow uses the exorbyte matchmaker server extension, which can be installed from the KNIME Partner Extensions Update Site.

exorbyte Postcode EnrichmentWorkflow descriptionThis workflow shows a postal code enrichment to address data with an existing exorbyteMatchMaker index. Address data containing only street, house number, and city name ismatched against the reference data containing postal codes in the MatchMaker index.Workflow requirementsexorbyte matchmaker server extension 2.0.xKNIME Analytics Platform >= 4.6, recommended 4.7 Step 1. Create queriesRead a file and rename columns with definedfield names. Note that these fields areindispensable in the query for a successfulexecution of the Matcher node. Step 2. Fuzzy MatchPerform a fuzzy match in an existingMatchMaker index on a server. The index is areference of address data containing postalcodes. Step 3. Process Match ResultsFilter Match Results so that only the goodmatches are used for the postcodeenrichment. The added postcode is thenjoined to the original data. perform fuzzy matchjoin original tablewith reference dataquality >= 220match_control is "A:ADDR_NOTPLZ"read query fileRequired MatchMaker fields:SOURCE_QID_QSTREETHNRLOCATION Matcher MM7.x Joiner Rule-basedRow Filter CSV Reader exorbyte Postcode EnrichmentWorkflow descriptionThis workflow shows a postal code enrichment to address data with an existing exorbyteMatchMaker index. Address data containing only street, house number, and city name ismatched against the reference data containing postal codes in the MatchMaker index.Workflow requirementsexorbyte matchmaker server extension 2.0.xKNIME Analytics Platform >= 4.6, recommended 4.7 Step 1. Create queriesRead a file and rename columns with definedfield names. Note that these fields areindispensable in the query for a successfulexecution of the Matcher node. Step 2. Fuzzy MatchPerform a fuzzy match in an existingMatchMaker index on a server. The index is areference of address data containing postalcodes. Step 3. Process Match ResultsFilter Match Results so that only the goodmatches are used for the postcodeenrichment. The added postcode is thenjoined to the original data. perform fuzzy matchjoin original tablewith reference dataquality >= 220match_control is "A:ADDR_NOTPLZ"read query fileRequired MatchMaker fields:SOURCE_QID_QSTREETHNRLOCATION Matcher MM7.x Joiner Rule-basedRow Filter CSV Reader

Nodes

Extensions

Links