Icon

Data Transformation Labs

Lab 2: Deriving Total Booking Cost with Math Formula

B Roopa sri [RA2311027010096]

Lab 3: Splitting User's Name

B Roopa sri [RA2311027010096]

Lab 4: Loyalty Points Categorization

B Roopa sri [RA2311027010096]

Lab 5: Structuring Food Orders for Analytics 

B Roopa sri [RA2311027010096]

Lab 1: Standardizing Movie Ratings and Titles

B Roopa sri(RA2311027010096)

Lab 6: Creating Booking Identifiers

B Roopa sri [RA2311027010096]

Lab 7: Creating Booking Cost Categories

B Roopa sri [RA2311027010096]

Lab 8: Normalizing Ticket Scans and Downloads

B Roopa sri [RA2311027010096]

Lab 9: Deriving Show Timings and Day Segments

B Roopa sri [RA2311027010096]

Lab 10: Normalizing Movie Ratings

B Roopa sri [RA2311027010096]

Read movie.csv
CSV Reader
Convert Rating datatypeto number
String to Number
Re-organise the column
Column Resorter
Remove duplicate rows
Duplicate Row Filter
Read booking.csv
CSV Reader
Read user.csv
CSV Reader
Read membership.csv
CSV Reader
Replace price_at_time to unit_price
Column Renamer
Remove whitespaces
String Manipulation
Replace rating missing values with mean values
Missing Value
Read foodorderitem.csv
CSV Reader
Add ₹ to total_item_cost
Expression
Renamed poster_image_url
Column Renamer
Calculate total_item_cost
Math Formula
Create a Constant column
Constant Value Column Appender
Categorize Booking Category
Expression
Create a booking identifier
Expression
Derive scan_status based on download and scan information
Rule Engine
Read ticket.csv
CSV Reader
Sort tickets based on scan_status
Sorter
Sort by total_cost
Sorter
Read booking.csv
CSV Reader
Calculate GST
Math Formula
Categorize show segment
Rule Engine
Read booking.csv
CSV Reader
Calculate Final cost + GST
Math Formula
Convert rating datatype
String to Number
Read show.csv
CSV Reader
Convert show_datatime to KNIME date format
String to Date&Time
Read movie.csv
CSV Reader
Extract hour of the day
Date&Time Part Extractor
Change column names
Column Renamer
Normalize Ratings on a scale of 0-5
Normalizer
Categorize a user into membership category
Rule Engine
Round Final cost upto 2 decimal places
Number Rounder
Remove Duplicate Movies
Duplicate Row Filter
Split into first and last name
Cell Splitter
Fill Missing values as Mean
Missing Value

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-08
Last update: 2026-06-09
Created with KNIME version: v5.8.3

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

Try NodePit Runner!