Sure!! Thank you for responding!
FILES---
Employees:
LOAD EmpID AS EmployeeID, [Last Name], [First Name], Title, [Hire Date], Office, Extension, [Reports To],
[Year Salary]
FROM
(biff, embedded labels, table is Employee$);
Employees_New:
LOAD EmpID AS EmployeeID, [Last Name], [First Name], Title, [Hire Date], Office, Extension, [Reports To],
[Year Salary]
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
QWT_Outsourced_Staff:
CrossTable([Business Consultant], Data)
LOAD DivisionID, [Business Consultant], [Financial Consultant], [IT Technician], [Cleaning Staff]
FROM
(biff, embedded labels, header is 1 lines, table is Sheet1$, filters(
Remove(Col, Pos(Top, 4))
));
Sales_Objectives:
LOAD
EmployeeID&'-'&OrderDate as IDEmpDate,
//Objective, EmpliyeeID
Objective
FROM
(biff, embedded labels, table is Sheet1$);
QUALIFY *;
UNQUALIFY "%*";
// Start of [Suppliers.xml] LOAD statements
Suppliers:
LOAD SupplierID as %SupplierID,
CompanyName,
ContactName,
Address,
City,
PostalCode,
Country,
Phone,
Fax
FROM (XmlSimple, Table is [Suppliers/_empty_]);
// End of [Suppliers.xml] LOAD statements
Data base-------
OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Qlikview\POCs\Ropa_Deportiva\DataSources\QWT.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];
Shipments:
LOAD CustomerID,
EmployeeID,
LineNo,
OrderID,
ProductID,
ShipmentDate,
ShipperID as %ShipperID;
SQL SELECT *
FROM Shipments;
Shippers:
LOAD CompanyName,
ShipperID as %ShipperID;
SQL SELECT *
FROM Shippers;
UNQUALIFY *;
Customers:
LOAD Address,
City,
CompanyName,
ContactName,
Country,
CustomerID,
DivisionID,
Fax,
Phone,
PostalCode,
StateProvince;
SQL SELECT *
FROM Customers;
Orders:
LOAD
EmployeeID&'-'&OrderDate as IDEmpDate,
CustomerID,
EmployeeID,
Freight,
OrderDate,
OrderID,
ShipperID as %ShipperID;
SQL SELECT *
FROM Orders;
Order_Details:
LOAD Discount,
LineNo,
OrderID,
ProductID,
Quantity;
// UnitPrice;
SQL SELECT *
FROM `Order Details`;
Divisions:
LOAD DivisionID,
DivisionName;
SQL SELECT *
FROM Divisions;
Products:
LOAD CategoryID,
ProductID,
ProductName,
QuantityPerUnit,
SupplierID as %SupplierID,
UnitCost,
UnitPrice,
UnitsInStock,
UnitsOnOrder;
SQL SELECT *
FROM Products;
Categories:
LOAD CategoryID,
CategoryName,
Description;
SQL SELECT *
FROM Categories;
