Icon

Data Transformation Labs Solution

Read membership.csv
CSV Reader
Read movie.csv
CSV Reader
Rename Columns
Column Renamer
Categorize a User intoMembership Category
Rule Engine
Sort bytotal_cost
Sorter
Read foodorderitem.csv
CSV Reader
Derive scan_status based on download and scan information
Rule Engine
Read booking.csv
CSV Reader
Categorize Booking Category
Expression
Add INR to total_cost
Expression
Rename price_at_timeto Unit Price
Column Renamer
Sort tickets by scan status
Sorter
Calculate total_item_cost
Math Formula
Read ticket.csv
CSV Reader
Read show.csv
CSV Reader
Fill Missing valuesas Mean
Missing Value
Read movie.csv
CSV Reader
Convert show_datetimeto KNIME Date/Time
String to Date&Time
Remove Duplicate Movies
Duplicate Row Filter
Extract Hour of the Day
Date&Time Part Extractor
Categorize ShowSegment
Rule Engine
Sort as perMovie Ratings
Sorter
Calculate GST
Math Formula
Fill Missing valuesas Mean
Missing Value
Convert Rating Data Type
String to Number
Calculate Final CostTotal + GST
Math Formula
Re-organize Columns
Column Resorter
Remove Duplicate Movies
Duplicate Row Filter
Normalize Ratingson a scale of 0-5
Normalizer
Read booking.csv
CSV Reader
Convert Rating Data Type
String to Number
Split into first &Last Name
Cell Splitter
Create a Booking Identifier
Expression
Change Column Names
Column Renamer
Round Final_Cost upto 2 decimal places
Number Rounder
Read booking.csv
CSV Reader
Read user.csv
CSV Reader
Create a ConstantColumn
Constant Value Column (deprecated)

Nodes

Extensions

Links