Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
H:
LOAD CategoryID,
CategoryName,
Description;
SQL SELECT * FROM Categories;
A:
LOAD
Address,
City,
CompanyName,
ContactName,
Country,
CustomerID,
DivisionID,
Fax,
Phone,
PostalCode,
StateProvince;
SQL SELECT * FROM Customers;
B:
LOAD
DivisionID,
DivisionName;
SQL SELECT * FROM Divisions;
C:
LOAD
Discount,
LineNo,
OrderID,
ProductID,
Quantity,
UnitPrice;
SQL SELECT * FROM `Order Details`;
😧
LOAD
CustomerID,
EmployeeID,
Freight,
OrderDate,
OrderID,
ShipperID;
SQL SELECT * FROM Orders;
E:
LOAD
CategoryID,
ProductID,
ProductName,
QuantityPerUnit,
SupplierID,
UnitCost,
UnitPrice,
UnitsInStock,
UnitsOnOrder;
SQL SELECT * FROM Products;
F:
LOAD
CustomerID,
EmployeeID,
LineNo,
OrderID,
ProductID,
ShipmentDate,
ShipperID;
SQL SELECT * FROM Shipments;
G:
LOAD
CompanyName,
ShipperID;
SQL SELECT * FROM Shippers;
Are you just trying to get somebody else to do your homework or do you want to know how to create a star schema? If the latter then can you tell us what you're having trouble with?
This will help you: Get started with developing qlik datamodels
- Marcus