Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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;

2 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
marcus_sommer
MVP & Luminary
MVP & Luminary

This will help you: Get started with developing qlik datamodels

- Marcus