Icon

xLender extra cleanup v4

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Fuzzy match to Clean names Standard names to use in Fuzzy match ETL Standard Names ETL New Names All Returned Data Standardize Common Names Reformat and match to Standard names Get nemes from Deed Lien.dbo.Lender_CleanupUnknownStandard NamesLender_Cleanup_Research_20231020Node 258Node 292Node 294LevenshteinNode 312Node 315Node 317Node 318Node 319Node 320Node 321UnknownNode 334Node 335Node 336Node 337Node 338LevenshteinNode 340LevenshteinNode 342Node 343LevenshteinNode 345Node 346Node 347Node 348Node 349> 1000Node 393Node 394Node 5replacestringscollect data fromlast iteration onlyreplace dataStd NamesDWS-ETL01AZUVPSQLDTDB029Deed.dbo.DeedNode 550Node 551Node 552Node 553Node 554Node 555Node 556Node 557Node 558Node 791Node 792AZUVPSQLDTDB029port 1: first rowport 2: remaining rowsNode 3Node 941Clean NamesNode 3Node 5collect data fromlast iteration onlyNode 946replacestringsStd Namesport 1: first rowport 2: remaining rowsNode 951Node 952Node 953Node 954Title Company cleaned KNode 957Node 958Node 959Node 960Node 961Node 963To be cleanedMatch TitleCoNode 996Node 998Node 999Node 1000CleanedInputNode 1003Not cleanedNode 1005Matched reformatNew and UnmatchedGood Fuzzy MatchMatched existingSend OffshoreNode 1015Node 1016Node 1017Node 1018Node 1019Node 1020Node 1021Node 1022CleanedNode 1024Node 1025Node 1026Matched stringNode 1028Node 1029Node 1030Node 1031Node 1032Node 1033Node 1034Add to CleanedNode 1036Node 1037AZUVPSQLDTDB029Lien.dbo.Lender_CleanupNode 1046New Lenders for Competent 20231121Node 1048Node 1049DB Table Selector Column Expressions DuplicateRow Filter DB Table Selector DB Reader Joiner Joiner String Matcher Rule-basedRow Splitter Sorter Column Resorter Column Rename(deprecated) Rule-basedRow Splitter String Manipulation String Manipulation Column Filter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Joiner Joiner String Matcher Sorter String Matcher Joiner Joiner String Matcher Joiner Joiner Concatenate Concatenate Concatenate Rule-basedRow Splitter DB Reader Sorter Table Row to Variable(deprecated) String Manipulation Recursive Loop End (2ports) (deprecated) Table Creator String Manipulation Microsoft SQLServer Connector Microsoft SQLServer Connector DB Table Selector DB Query DB Query DB Query DB Query DB Concatenate DB Concatenate DB Concatenate DB Query DB Reader Sorter Rule-basedRow Splitter Microsoft SQLServer Connector Row Splitter Recursive Loop Start(2 ports) (deprecated) String Manipulation Column Filter Recursive Loop Start(2 ports) (deprecated) Table Row to Variable(deprecated) Recursive Loop End (2ports) (deprecated) String Manipulation String Manipulation String Manipulation Row Splitter Sorter DuplicateRow Filter Joiner Sorter Excel Reader Rule-basedRow Splitter Joiner GroupBy Joiner Sorter Column Filter Column Filter Column Filter Joiner Joiner Concatenate Sorter Column Expressions Column Resorter StandardizeCommon Lenders Column Resorter Rule-basedRow Splitter Column Filter Rule-basedRow Splitter Sorter Column Filter Column Filter Column Renamer Column Renamer Column Filter String Manipulation String Manipulation Column Filter Column Filter Column Renamer Column Expressions Column Renamer Column Filter Concatenate Column Filter DuplicateRow Filter DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Microsoft SQLServer Connector DB Table Selector DB Reader Excel Writer DB Writer Column Renamer Fuzzy match to Clean names Standard names to use in Fuzzy match ETL Standard Names ETL New Names All Returned Data Standardize Common Names Reformat and match to Standard names Get nemes from Deed Lien.dbo.Lender_CleanupUnknownStandard NamesLender_Cleanup_Research_20231020Node 258Node 292Node 294LevenshteinNode 312Node 315Node 317Node 318Node 319Node 320Node 321UnknownNode 334Node 335Node 336Node 337Node 338LevenshteinNode 340LevenshteinNode 342Node 343LevenshteinNode 345Node 346Node 347Node 348Node 349> 1000Node 393Node 394Node 5replacestringscollect data fromlast iteration onlyreplace dataStd NamesDWS-ETL01AZUVPSQLDTDB029Deed.dbo.DeedNode 550Node 551Node 552Node 553Node 554Node 555Node 556Node 557Node 558Node 791Node 792AZUVPSQLDTDB029port 1: first rowport 2: remaining rowsNode 3Node 941Clean NamesNode 3Node 5collect data fromlast iteration onlyNode 946replacestringsStd Namesport 1: first rowport 2: remaining rowsNode 951Node 952Node 953Node 954Title Company cleaned KNode 957Node 958Node 959Node 960Node 961Node 963To be cleanedMatch TitleCoNode 996Node 998Node 999Node 1000CleanedInputNode 1003Not cleanedNode 1005Matched reformatNew and UnmatchedGood Fuzzy MatchMatched existingSend OffshoreNode 1015Node 1016Node 1017Node 1018Node 1019Node 1020Node 1021Node 1022CleanedNode 1024Node 1025Node 1026Matched stringNode 1028Node 1029Node 1030Node 1031Node 1032Node 1033Node 1034Add to CleanedNode 1036Node 1037AZUVPSQLDTDB029Lien.dbo.Lender_CleanupNode 1046New Lenders for Competent 20231121Node 1048Node 1049 DB Table Selector Column Expressions DuplicateRow Filter DB Table Selector DB Reader Joiner Joiner String Matcher Rule-basedRow Splitter Sorter Column Resorter Column Rename(deprecated) Rule-basedRow Splitter String Manipulation String Manipulation Column Filter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Joiner Joiner String Matcher Sorter String Matcher Joiner Joiner String Matcher Joiner Joiner Concatenate Concatenate Concatenate Rule-basedRow Splitter DB Reader Sorter Table Row to Variable(deprecated) String Manipulation Recursive Loop End (2ports) (deprecated) Table Creator String Manipulation Microsoft SQLServer Connector Microsoft SQLServer Connector DB Table Selector DB Query DB Query DB Query DB Query DB Concatenate DB Concatenate DB Concatenate DB Query DB Reader Sorter Rule-basedRow Splitter Microsoft SQLServer Connector Row Splitter Recursive Loop Start(2 ports) (deprecated) String Manipulation Column Filter Recursive Loop Start(2 ports) (deprecated) Table Row to Variable(deprecated) Recursive Loop End (2ports) (deprecated) String Manipulation String Manipulation String Manipulation Row Splitter Sorter DuplicateRow Filter Joiner Sorter Excel Reader Rule-basedRow Splitter Joiner GroupBy Joiner Sorter Column Filter Column Filter Column Filter Joiner Joiner Concatenate Sorter Column Expressions Column Resorter StandardizeCommon Lenders Column Resorter Rule-basedRow Splitter Column Filter Rule-basedRow Splitter Sorter Column Filter Column Filter Column Renamer Column Renamer Column Filter String Manipulation String Manipulation Column Filter Column Filter Column Renamer Column Expressions Column Renamer Column Filter Concatenate Column Filter DuplicateRow Filter DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Concatenate DuplicateRow Filter Microsoft SQLServer Connector DB Table Selector DB Reader Excel Writer DB Writer Column Renamer

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: minelson
Created at: 2022-07-19
On NodePit since: 2023-11-28
Last update: 2024-11-21
Created with KNIME version: v5.1.0

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

Try NodePit Runner!