Icon

KNIME_​project_​DWBI_​final_​v2

Rows added to Vendor Table
DB Row Inserter
TaxiType_FKReady
Column Renamer
Green Trip Data
Parquet Reader
Yellow Trip Data
Parquet Reader
Yellow and Green DatasetWith all fields needed for db
Concatenate
Rows added to RateCode Table
DB Row Inserter
Column Filter
DB Table Selector
Rows added to Payment TypeTable
DB Row Inserter
CSV Reader
Adding Vendor FK
Joiner
Vendor table
DB Reader
Renaming column to Vendor FK
Column Renamer
Duplicate Row Filter
Duplicate Row Filter
Column Renamer
Column Filter
PaymentType Table ready
Rule Engine
Column Renamer
FIlter Vendor ID
Column Filter
PaymentType
DB Reader
Insert Location Table TO db
DB Row Inserter
RateCode
DB Reader
RateCode Table Ready
Rule Engine
DB Table Selector
DB Table Selector
DB Table Selector
Joining Payment TyPE
Joiner
Location
DB Reader
Clean missing or 0 vals
Row Filter
YELLOWClean Dropoff < pickup
Rule-based Row Filter
Clean missing or 0 vals
Row Filter
GREENClean Dropoff < pickup
Rule-based Row Filter
Vendor Table Ready
Rule Engine
Duplicate Row Filter
Duplicate Row Filter
TaxiType Table Ready
Rule Engine
Column Filter
Add TripDuration Col
Date&Time Difference
rENAME COL to PaymentType_FK
Column Renamer
Rename Pickup & Dropoff Cols
Column Renamer
Microsoft SQL Server Connector
Rename Pickup & Dropoff Cols
Column Renamer
Rename TotalAmount to Revenue
Column Renamer
Join RareCode
Joiner
PickUpDateTime_FK
Joiner
Join Location for Pickup
Joiner
Rows added to DateTimeTable
DB Row Inserter
Rename Col to RateCode_FK
Column Renamer
DB Table Selector
Constant Value Column Appender
Rename col toPickup_Location_FK
Column Renamer
datetime table
DB Reader
Remove the T from the fulldatetime
Date&Time to String
Column Filter
Rename to FullDateTime
Column Renamer
Constant Value Column Appender
Add TimeBand Column
Rule Engine
Rename to FullDateTime
Column Renamer
Column Filter
Extract separate datetime fileds
Date&Time Part Extractor
Rename col to Dropoff_Location_FK&&PassengerCount&&TripDistance
Column Renamer
Add IsWeekend Column
Rule Engine
Join llocation for Dropoff
Joiner
Replacing the null values in RateCode with the code -1 for Not Provided
Rule Engine
remove date duplicates
Duplicate Row Filter
Replacing the null values in payment type with the code -1 for Not Provided
Rule Engine
Row Filter
YellowFilter Columns
Column Filter
Dropoff_DateTime_FK ReadyDatetime table joined correctly
Column Renamer
Replace passenger count NULL to 1
Missing Value
GreenFilter PassCount
Column Filter
Concatenate
Joiner
Location Table Ready
Column Renamer
PickUpDateTime_FKReady
Column Renamer
Insert Fact Table Trip TO db
DB Row Inserter
TaxiType table
DB Reader
Rows added to TaxiType Table
DB Row Inserter
Joiner
DB Table Selector

Nodes

Extensions

Links