Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have 3 tables sales products and Budget( crosstable table)
The goal of join between 3 tables and comparing a sales table with a budget table by products and by months (in Data load editor) ?
Attached to the table structure:
Budget:
CrossTable(Month,Budget,1)
LOAD
CategoryID,
Jan,
Feb,
Mar,
Apr,
May,
Jun,
Jul,
Aug,
Sep,
Oct,
Nov,
Dec
FROM Budget (qvd);
Sales:
LOAD
CustomerID,
OrderDate,
OrderID,
ProductID,
QTY,
AMOUNT,
CANCEL_FLAG
FROM Sales.qvd (qvd);
Products:
LOAD
CategoryID,
ProductID,
ProductName,
SupplierID,
"TYPE" as protype
FROM Products (qvd);
Thanks
Currently your data does not have any common date dimensions to do this comparison.
You can create a month field in Sales table:
Sales:
LOAD
CustomerID,
OrderDate,
Month(OrderDate) as Month,
OrderID,
ProductID,
QTY,
AMOUNT,
CANCEL_FLAG
FROM Sales.qvd (qvd);
But you still only see your budget at Category level, so you cannot compare your product sales with your budget except at this level.