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