Icon

KNIME_​infer_​addresses

Sample Address DataRow identifierSplit by commasFind allalphanumeric blocksincluding hyphensSuggestPostcodeandBuilding NumberBuilding Numberassumed to be first numeric sequence encounteredPost codeRemove numeric blocksfrom all extracted colsPredict RegionBlock 4 or Block 3Predict StreetFirst non-numeric blockMake any spaces intoMissing ValuesPredict VillageBlock 2 if there are4 blocksOtherwise blankPredict Town or Cityas either Block 3 if there are4 Blocks, or Block 2 if thereare 3 or 2 blocksTidy upResquence colsExcel Reader Counter Generation Cell Splitter Regex Extractor Column Rename Column Merger Column Merger Column Expressions Rule Engine Rule Engine Set Valuesto Missing Rule Engine Rule Engine Column Filter Column Resorter Sample Address DataRow identifierSplit by commasFind allalphanumeric blocksincluding hyphensSuggestPostcodeandBuilding NumberBuilding Numberassumed to be first numeric sequence encounteredPost codeRemove numeric blocksfrom all extracted colsPredict RegionBlock 4 or Block 3Predict StreetFirst non-numeric blockMake any spaces intoMissing ValuesPredict VillageBlock 2 if there are4 blocksOtherwise blankPredict Town or Cityas either Block 3 if there are4 Blocks, or Block 2 if thereare 3 or 2 blocksTidy upResquence colsExcel Reader Counter Generation Cell Splitter Regex Extractor Column Rename Column Merger Column Merger Column Expressions Rule Engine Rule Engine Set Valuesto Missing Rule Engine Rule Engine Column Filter Column Resorter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-05-22
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!