Icon

Data Transformation Labs - ROEHAN RANGANATHAN - RA2311030010074-919

Lab 2: Deriving Total Booking Cost with Math Formula

Lab 3: Splitting User's Name

Lab 4: Loyalty Points Categorization

Lab 5: Structuring Food Orders for Analytics 

Lab 1: Standardizing Movie Ratings and Titles

Lab 6: Creating Booking Identifiers

Lab 7: Creating Booking Cost Categories

Lab 8: Normalizing Ticket Scans and Downloads

Lab 9: Deriving Show Timings and Day Segments

Lab 10: Normalizing Movie Ratings

ROEHAN RANGANATHAN - RA2311030010074-919

CSV Reader
Read booking.csv
CSV Reader
create constant column
Constant Value Column Appender
calc GST
Math Formula
Calc final cost + GST
Math Formula
Round final cost upto 2 decimal places
Number Rounder
Row Sampler
String Manipulation
create a book identifier
Expression
read booking
CSV Reader
Ticket csv
CSV Reader
derive scan_status based on download and scan information
Rule Engine
categorize booking category
Expression
sort total_cost
Sorter
extract hour of the day
Date&Time Part Extractor
scan ticket by scan status
Sorter
Read ticket csv
CSV Reader
convert show date_time
String to Date&Time
rename as first name and last name
Column Renamer
read movie
CSV Reader
Rule Engine
read user
CSV Reader
re-organize columns
Column Resorter
fill missing value as mean
Missing Value
split into first name and last name
Cell Splitter
read fooditemorder
CSV Reader
normalize rating on a scale of 0-5
Normalizer
read membership
CSV Reader
convert rating data type
String to Number
categorize a user into membership category
Rule Engine
remove duplicate movies
Duplicate Row Filter
add inr to total cost
Expression
String Manipulation
read booking
CSV Reader
rename price at time to unit price
Column Renamer
calculate total_item_cost
Math Formula
Rule Engine

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: adhik
Created at: 2025-10-23
On NodePit since: 2026-06-09
Last update: 2026-06-09
Created with KNIME version: v5.8.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!