topic Re: can u please built example script to built star schema with following Date please in QlikView

can u please built example script to built star schema with following Date please

Wed, 23 Dec 2015 18:25:23 GMT

LOAD CategoryID,

CategoryName,

Description;

SQL SELECT * FROM Categories;

LOAD

Address,

City,

CompanyName,

ContactName,

Country,

CustomerID,

DivisionID,

Fax,

Phone,

PostalCode,

StateProvince;

SQL SELECT * FROM Customers;

LOAD

DivisionID,

DivisionName;

SQL SELECT * FROM Divisions;

LOAD

Discount,

LineNo,

OrderID,

ProductID,

Quantity,

UnitPrice;

SQL SELECT * FROM `Order Details`;

😧

LOAD

CustomerID,

EmployeeID,

Freight,

OrderDate,

OrderID,

ShipperID;

SQL SELECT * FROM Orders;

LOAD

CategoryID,

ProductID,

ProductName,

QuantityPerUnit,

SupplierID,

UnitCost,

UnitPrice,

UnitsInStock,

UnitsOnOrder;

SQL SELECT * FROM Products;

LOAD

CustomerID,

EmployeeID,

LineNo,

OrderID,

ProductID,

ShipmentDate,

ShipperID;

SQL SELECT * FROM Shipments;

LOAD

CompanyName,

ShipperID;

SQL SELECT * FROM Shippers;

Re: can u please built example script to built star schema with following Date please

Gysbert_Wassenaar — Thu, 24 Dec 2015 17:26:26 GMT

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?

Re: can u please built example script to built star schema with following Date please

marcus_sommer — Sun, 27 Dec 2015 13:01:28 GMT

This will help you: Get started with developing qlik datamodels

- Marcus