Relational data indexed

vingodengr

I have three tables (for example)

Sales table = Date, productID, qty, amount, customerID

Customer table = CustomerID, First, Last, Phone, email, loyalty points

Product table = ProductID, origin, weight, lead time, price, aisle#, supplier, category

How to connect these for analysis?

MartinLiebig

Hi,

probably you want to use a join? Maybe check out this video: https://academy.rapidminer.com/learn/video/joining-and-cleansing-intro

Best,

Martin