Icon

For Sharing

Square footage alignment Create a DB to store lats & lons retrievedfrom Google Open LatLon DB Append listings with LatLon, retrieve from Google only when new Check over columns and remove duplicates, then update or insert new listings into DB (works, but takes significant amount of time) Create a DB to store listings Open RETSdb Removing empty/unneeded columns Time stamp workflow (i.e., first time ML Number retrieved fromCSVs, and then updated time stamp if the same)(not confirmed to work as expected) Check folder for latest file KNIME Timestamp Tableau Timestamp Finalize and publish Postal Codesto LatLonAll Inclsv to N if blank;Approx Age TBD if blankChange 0 Age to NewSplit SqFt RangeRenaming SqFtColumnsCalc SqFt MidpointSplit LatLonto Lat & LonIf 0sqft then349sqftFix datesNo locker toN caseY locker to just YNode 26Node 27Store LatLonNode 29Node 30Node 31Join in theLat LonsExtract column headerFilter duplicated columns(by default containing " (right)")Tranpose to a single columnMerges the duplicated columnsEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilter duplicated columns(by default containing " (right)")Create a column of deduplicated column headersFilters the top row for column merger nodeConverts the top row into flow variablesObtain the number of duplicated columnsSet the number as a flow variableonly geo-code the uniquevalues to prevent superfluousrequestsAdd new LatLonto Postal CodesNode 279Node 280Node 298Node 299Node 300Node 301Node 302Node 303Node 304Node 305current timestart_timestart_timelast_updatedlast_updatedfirst_insertedfirst_insertedNode 1930Node 1931Node 1932Remove emptycolumnsNode 1949Node 1950Node 1951Node 1952Node 1953Node 1954Bring back tooriginal tableNode 1956Node 1957If 5000+current timestart_timestart_timelast_updatedlast_updatedNode 1963Sample CSV in lieu of first green box Google AddressGeocoder Missing Value String Replacer Cell Splitter Column Rename Math Formula Coordinate toLatitude/Longitude Rule Engine String to Date&Time String Manipulation Rule Engine SQLite Connector DB Table Creator DB Merge DB Table Selector DB Query DB Reader Joiner ExtractColumn Header Row Filter Transpose Column Merger Recursive LoopEnd (deprecated) Recursive LoopStart (deprecated) ExtractColumn Header Transpose Row Filter String Manipulation Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable GroupBy Joiner Column Filter String To Number String to URI List Files/Folders String Manipulation Sorter File MetaInfo (legacy) CSV Reader Table Rowto Variable Row Filter Create Date&TimeRange Table Rowto Variable ConstantValue Column String to Date&Time ConstantValue Column String to Date&Time SQLite Connector DB Table Creator Column Filter Missing ValueColumn Filter DB Table Selector DB Query DB Reader Joiner DB Merge Column Rename Concatenate String To Number String To Number Rule Engine Create Date&TimeRange Table Rowto Variable ConstantValue Column String to Date&Time String Manipulation Table Creator Square footage alignment Create a DB to store lats & lons retrievedfrom Google Open LatLon DB Append listings with LatLon, retrieve from Google only when new Check over columns and remove duplicates, then update or insert new listings into DB (works, but takes significant amount of time) Create a DB to store listings Open RETSdb Removing empty/unneeded columns Time stamp workflow (i.e., first time ML Number retrieved fromCSVs, and then updated time stamp if the same)(not confirmed to work as expected) Check folder for latest file KNIME Timestamp Tableau Timestamp Finalize and publish Postal Codesto LatLonAll Inclsv to N if blank;Approx Age TBD if blankChange 0 Age to NewSplit SqFt RangeRenaming SqFtColumnsCalc SqFt MidpointSplit LatLonto Lat & LonIf 0sqft then349sqftFix datesNo locker toN caseY locker to just YNode 26Node 27Store LatLonNode 29Node 30Node 31Join in theLat LonsExtract column headerFilter duplicated columns(by default containing " (right)")Tranpose to a single columnMerges the duplicated columnsEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilter duplicated columns(by default containing " (right)")Create a column of deduplicated column headersFilters the top row for column merger nodeConverts the top row into flow variablesObtain the number of duplicated columnsSet the number as a flow variableonly geo-code the uniquevalues to prevent superfluousrequestsAdd new LatLonto Postal CodesNode 279Node 280Node 298Node 299Node 300Node 301Node 302Node 303Node 304Node 305current timestart_timestart_timelast_updatedlast_updatedfirst_insertedfirst_insertedNode 1930Node 1931Node 1932Remove emptycolumnsNode 1949Node 1950Node 1951Node 1952Node 1953Node 1954Bring back tooriginal tableNode 1956Node 1957If 5000+current timestart_timestart_timelast_updatedlast_updatedNode 1963Sample CSV in lieu of first green box Google AddressGeocoder Missing Value String Replacer Cell Splitter Column Rename Math Formula Coordinate toLatitude/Longitude Rule Engine String to Date&Time String Manipulation Rule Engine SQLite Connector DB Table Creator DB Merge DB Table Selector DB Query DB Reader Joiner ExtractColumn Header Row Filter Transpose Column Merger Recursive LoopEnd (deprecated) Recursive LoopStart (deprecated) ExtractColumn Header Transpose Row Filter String Manipulation Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable GroupBy Joiner Column Filter String To Number String to URI List Files/Folders String Manipulation Sorter File MetaInfo (legacy) CSV Reader Table Rowto Variable Row Filter Create Date&TimeRange Table Rowto Variable ConstantValue Column String to Date&Time ConstantValue Column String to Date&Time SQLite Connector DB Table Creator Column Filter Missing ValueColumn Filter DB Table Selector DB Query DB Reader Joiner DB Merge Column Rename Concatenate String To Number String To Number Rule Engine Create Date&TimeRange Table Rowto Variable ConstantValue Column String to Date&Time String Manipulation Table Creator

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: aqudi
Created at: 2022-09-02
On NodePit since: 2023-03-20
Last update: 2024-09-07
Created with KNIME version: v4.7.1

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

Try NodePit Runner!