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.)