Icon

PSBA_​2-2_​CGV

WEEK 1

CSV Reader - Imports data from a CSV file in to KNIME for purchasing and analysis.

Table View - Displays the processed data in a table format for easy viewing and checking.

WEEK 2

Structured Data - Excel file containing customer master records.

Structured Data - CSV file containing transaction records.

Preview of transaction data - used to check column names, data types, and records.

Preview of customer data - used to check column names, data types, and records.

Shared Key: Customer_ID -- can be used to connect the Transactions and Customer Master tables

WEEK 3

DATA INDIGESTION

WEEK 4

WEEK 5

WEEK 6

CSV Reader
Table View
Row Filter
CSV Reader
Table View
Table View
Excel Reader
Excel Reader
Concatenate
Joiner
Excel Reader
Excel Reader
CSV Reader
Column Filter
Concatenate
Math Formula
Excel Reader
Excel Reader
Excel Reader
GroupBy
String Manipulation
CSV Reader
Column Filter
Table View
Row Filter
Column Filter
Excel Reader
Row Filter

Nodes

Extensions

Links