Icon

Customer Transaction Analyis --Part 1--

1. Access the Data

2.Clean the Data

Clean the Customer Information System 1

  • From File(s)

1.

2.

3.

  • From a Database

3.Data Transformation

4.Data Cleaning and Data Transformation Metanode

Customer Information System 2

Transform the Customer Information System 1

L1 Project - Excercises

Customer Transactions Analysis --Part 1--

Table Check and Final Transformations

Table Check and Final Transformations

Hello! 👋


This is my first publication, focusing on data accessing, data cleaning, and data transformation, created as part of my L1-AP Certificate journey.

Through this work, I explored the full data preparation pipeline—turning raw data into structured, meaningful insights and laying the foundation for further analysis.

Excited to share this milestone and continue growing in the world of data 🚀

Split CustomerIDand CustomerGroup
Cell Splitter
DB Table Selector
Excel Reader
Rename newcolumns
Column Renamer
Table Reader
CSV Reader
SQLite Connector
Missing Value
Table Cropper
Table Manipulator
Duplicate Row Filter
Expression
Table Manipulator
Expression
Merge email andcorporate email
Column Merger
Data Cleaning and Data Transformation
DB Reader
DB Table Selector
DB Reader

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: kosta
Created at: 2026-01-25
On NodePit since: 2026-01-28
Last update: 2026-01-28
Created with KNIME version: v5.9.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!