Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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

This will help you: Get started with developing qlik datamodels

- Marcus