Icon

Customer Data Integration for a Retail Company

You are working as a data analyst for a retail company that has recently acquired another smaller retail chain.Your task is to integrate the customer data from both companies into a single, clean dataset. You need to ensurethe data is accurate, consistent, and ready for further analysis.The data consists of two CSV files:company_a_customers.csvcompany_b_customers.csv Customers A.CsvCustomer B.CSVConcate both csv Dropping Duplicate rowsFirst name from email idid uniqueID UniqueNode 29Node 39 CSV Reader CSV Reader Concatenate DuplicateRow Filter Cell Splitter String Manipulation String Manipulation Cell Splitter Column Filter Phone numbercleaning Date Formating You are working as a data analyst for a retail company that has recently acquired another smaller retail chain.Your task is to integrate the customer data from both companies into a single, clean dataset. You need to ensurethe data is accurate, consistent, and ready for further analysis.The data consists of two CSV files:company_a_customers.csvcompany_b_customers.csv Customers A.CsvCustomer B.CSVConcate both csv Dropping Duplicate rowsFirst name from email idid uniqueID UniqueNode 29Node 39 CSV Reader CSV Reader Concatenate DuplicateRow Filter Cell Splitter String Manipulation String Manipulation Cell Splitter Column Filter Phone numbercleaning Date Formating

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: girib
Created at: 2024-07-06
On NodePit since: 2024-07-06
Last update: 2024-11-21
Created with KNIME version: v5.2.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!