Demo: From Excel to KNIME

This workflow shows how to access Excel & CSV files in KNIME, how to preprocess the data (concatenate data tables, check for duplicates, and perform a VLOOKUP), how to create a Pivot table, and how to visualize & export the processed data.

The three datasets used in the workflow are:

CRM1.xlsx: Excel file with information about customers (e.g., Customer ID, Sales Unit, etc.)
CRM2.csv: CSV file containing customer information from another CRM
Transactions.csv: Information about transactions from an ERP system (e.g., Customer ID, Product ID, Price, etc.)

challenge-2

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME JavasnippetTrusted extension

Legal

KNIME Base nodes

KNIME Javasnippet