Icon

IT2212_​assignment_​253955B

2. Source Standardisation

3. Data Mashup

4. Data Quality Assessment

5. Data Cleaning

6. Anonymisation

7. Data Transformation

8. Data Analysis and Charts

9. Output and Validation

1. Data Input

10. Export Cleaned Dataset

Add South Region
Constant Value Column Appender
Rename Total Amount Spent
Column Renamer
Order South Columns
Column Resorter
Rename Card Status Spending
Column Renamer
Merge All Regions
Concatenate
Pivot Credit Card Status
Pivot
Calculate Spending by Region and Card Status
GroupBy
Chart Total Spending by Region
Bar Chart
Count Records by SSN
GroupBy
Calculate Average Spending by Age Group
GroupBy
Find Duplicate SSNs
Row Filter
Rename Average Amount Spent
Column Renamer
Generate New Row IDs
RowID
Rename Card Status Columns
Column Renamer
Explore Merged Data
Statistics View
Chart Spending by Card Status
Bar Chart
Split Invalid Birth Years
Rule-based Row Splitter
Correct Birthdate Century
Date Shifter
Remove Duplicate SSNs
Duplicate Row Filter
Extract Birth Year
Date&Time Part Extractor
Sort Age Groups
Sorter
Remove Age Group Order
Column Filter
Create Age Group Order
Rule Engine
Regenerate Row IDs After Date Correction
RowID
Count Records per Customer ID
GroupBy
Remove BirthYear
Column Filter
Find Duplicate Customer IDs
Rule-based Row Filter
Chart Average Spending by Age Group
Bar Chart
Recombine Corrected Birthdates
Concatenate
Validate Final Dataset
Statistics
Rename Regional Median Income
Column Renamer
Write Cleaned Dataset
Excel Writer
Join Regional Median Income
Joiner
Mark Invalid Numeric Values Missing
Expression
Count Customers by Region
GroupBy
Calculate Regional Median Income
GroupBy
Rename Regional Customer Count
Column Renamer
Restore Income Integer Type
Double to Integer
Impute Regional Income Median
Expression
Remove Regional Median Helper
Column Filter
Read East Data
Excel Reader
Read North Data
Excel Reader
Read South Data
Excel Reader
Read West Data
Excel Reader
Add East Region
Constant Value Column Appender
Order East Columns
Column Resorter
Add West Region
Constant Value Column Appender
Keep Valid Spending Records
Rule-based Row Filter
Median Spending by Purchases
GroupBy
Impute Median Purchases
Missing Value
Restore Purchases Integer Type
Double to Integer
Impute Amount by Purchase Count
Expression
Remove Median Spending Helper
Column Filter
Rename Median Spending Column
Column Renamer
Join Median Spending Lookup
Joiner
Restore Amount Spent Integer Type
Double to Integer
Calculate Customer Age
Date&Time Difference
Create Age Groups
Numeric Binner
Calculate Average Spend per Purchase
Expression
Split North Name
Cell Splitter
Anonymise Customer SSN
Anonymization
Create Income Bands
Numeric Binner
Create Credit Card Status
Rule Engine
Order West Columns
Column Resorter
Add North Region
Constant Value Column Appender
Arrange Final Cleaned Dataset
Column Resorter
Trim North Name
String Manipulation
Order North Columns
Column Resorter
Generate Final Row IDs
RowID
Rename North Names
Column Renamer
Rename Customer Identifier
Column Renamer
Remove Original Name
Column Filter
Remove Unnecessary Personal Fields
Column Filter
Rename South Names
Column Renamer
Remove South Name
Column Filter
Trim South Name
String Manipulation
Calculate Total Spending by Region
GroupBy
Split South Name
Cell Splitter

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: waiya
Created at: 2026-07-14
On NodePit since: 2026-07-16
Last update: 2026-07-17
Created with KNIME version: v5.11.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!