Icon

KNIME_​project 1

Address Deduplication( Finding most similiar row from the same table). Considering first name and address to matching with each row.Most similiar row will be stored in columns prefixed with 'ref'. Simple similarity check of two columns. Import your excel here Using Google map address auto complete api to fetch addresses similiar to Address1 and city column Column matching(OP_FIRST_NAME matching with OP_LAST_NAME). Scale of 0 to 1, where 0 is fully matched. Zip code and address validation Phone Number Validation Using Plivo Using numlookupapi Using Twilio Join reference addresscolumns to columns ofaddress data set withduplicates2-gram dice distanceon 'name'2-gram dice distanceon 'address'Aggregated distanceFind most similardata row of referenceaddress data setfor each data row ofaddress data set withduplicatesprepend toeach column:"ref"Append originalrow id as columnCreate unique reference addressdata setUsing to import Excel sheet dataComparing first namesComparing last namesComparing Address1Comparing Address2Mean of similaritiesPercentage of similarityNode 70Custom tableNode 99Node 100Node 101Node 103Node 104Node 105Node 106Node 107Node 108Node 113Node 114Node 115Node 116Node 117Node 118 Rick click and view table view Rick click and view table view Rick click and view table viewUsing to import Excel sheet dataNode 127Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141Node 142Node 144Custom tableNode 147Node 148Node 149Node 151Node 152Node 153Node 155Node 156Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165Node 166 Rick click and view table view Joiner (deprecated) Rule Engine String Distances String Distances Aggregated Distance Similarity Search Column Rename(Regex) RowID GroupBy Excel Reader String Similarity String Similarity String Similarity String Similarity Column Aggregator Math Formula InteractiveTable (local) Table Creator Row Sampling Concatenate Column Splitter String Manipulation String Manipulation GET Request String Manipulation JSON to Table Column Splitter Column Distance String Distances String Distances String Manipulation String Manipulation Column Splitter InteractiveTable (local) InteractiveTable (local) InteractiveTable (local) Excel Reader Column Splitter String Manipulation GET Request String Manipulation JSON to Table Rule Engine String Manipulation Column Splitter GET Request JSON to Table Rule Engine Column Splitter Rule Engine Rule Engine String Manipulation Excel Writer Table Creator String Manipulation String Manipulation Rule Engine Column Expressions String Manipulation GET Request JSON to Table Row Filter Column Splitter String Manipulation GET Request JSON to Table Column Splitter Rule Engine String Manipulation GET Request JSON to Table Column Splitter InteractiveTable (local) Address Deduplication( Finding most similiar row from the same table). Considering first name and address to matching with each row.Most similiar row will be stored in columns prefixed with 'ref'. Simple similarity check of two columns. Import your excel here Using Google map address auto complete api to fetch addresses similiar to Address1 and city column Column matching(OP_FIRST_NAME matching with OP_LAST_NAME). Scale of 0 to 1, where 0 is fully matched. Zip code and address validation Phone Number Validation Using Plivo Using numlookupapi Using Twilio Join reference addresscolumns to columns ofaddress data set withduplicates2-gram dice distanceon 'name'2-gram dice distanceon 'address'Aggregated distanceFind most similardata row of referenceaddress data setfor each data row ofaddress data set withduplicatesprepend toeach column:"ref"Append originalrow id as columnCreate unique reference addressdata setUsing to import Excel sheet dataComparing first namesComparing last namesComparing Address1Comparing Address2Mean of similaritiesPercentage of similarityNode 70Custom tableNode 99Node 100Node 101Node 103Node 104Node 105Node 106Node 107Node 108Node 113Node 114Node 115Node 116Node 117Node 118 Rick click and view table view Rick click and view table view Rick click and view table viewUsing to import Excel sheet dataNode 127Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141Node 142Node 144Custom tableNode 147Node 148Node 149Node 151Node 152Node 153Node 155Node 156Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165Node 166 Rick click and view table view Joiner (deprecated) Rule Engine String Distances String Distances Aggregated Distance Similarity Search Column Rename(Regex) RowID GroupBy Excel Reader String Similarity String Similarity String Similarity String Similarity Column Aggregator Math Formula InteractiveTable (local) Table Creator Row Sampling Concatenate Column Splitter String Manipulation String Manipulation GET Request String Manipulation JSON to Table Column Splitter Column Distance String Distances String Distances String Manipulation String Manipulation Column Splitter InteractiveTable (local) InteractiveTable (local) InteractiveTable (local) Excel Reader Column Splitter String Manipulation GET Request String Manipulation JSON to Table Rule Engine String Manipulation Column Splitter GET Request JSON to Table Rule Engine Column Splitter Rule Engine Rule Engine String Manipulation Excel Writer Table Creator String Manipulation String Manipulation Rule Engine Column Expressions String Manipulation GET Request JSON to Table Row Filter Column Splitter String Manipulation GET Request JSON to Table Column Splitter Rule Engine String Manipulation GET Request JSON to Table Column Splitter InteractiveTable (local)

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: akhil_000
Created at: 2022-06-06
On NodePit since: 2022-06-09
Last update: 2024-11-21
Created with KNIME version: v4.5.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!