Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

daniela_becerra
New Contributor

Mapping Load

Hi everyone!!

I am new to Qlikview and I am having a hard time with an excersie that has to do with mapping.... I have tryed to follow some of the inqueries other uses have posted, but the questions are directed when you already have tables created. I am just uploading the information to my Qlikview... So I am supposed to use the "Mapping LOAD * FROM file_name.ext", but when I do so, I get the following error message

"File not found error

Cannot open file: 'C:\Qlikview\POCs\Ropa_Deportiva\Documents\QWT.mdb'

System error: Filesystem::FindImpl FindFirst call: Incorrect function: "C:\Qlikview\POCs\Ropa_Deportiva\Documents"

Mapping LOAD *

FROM QWT.mdb"

Probably it is an easy fix matter... but I am really having a hard time trying to get .

Thanks for your time and help, in advance.

7 Replies

Re: Mapping Load

Can You share your load script.

daniela_becerra
New Contributor

Re: Mapping Load

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 OLEDBSmiley Frustratedystem database="";Jet OLEDB:Registry Path="";Jet OLEDBSmiley Very Happyatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBSmiley Very Happyatabase 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 OLEDBSmiley Very Happyon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDBSmiley FrustratedFP=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;

daniela_becerra
New Contributor

Re: Mapping Load

I would have to map tables:

Divisions, Categories (Categories_A, Categories_B), Shippers and Products, so the final modle would be a Snowflake.... but I have no clue as of how to do that...

Re: Mapping Load

I am asking Mapping script also it is possible you can share sample file.

daniela_becerra
New Contributor

Re: Mapping Load

Oh  sorry.... I do not have a Mapping script... I was left to find out how to do it, so honestly I have been reading information here and there... but nothing really makes sense to me...

daniela_becerra
New Contributor

Re: Mapping Load

This was all I was left with "Mapping LOAD * FROM file_name.ext"

daniela_becerra
New Contributor

Re: Mapping Load

But I have tryed multiple ways being these two some of them:

Divisions_map:

Mapping LOAD DivisionID,

    DivisionName

FROM Divisions;

Divisions_map:

Mapping LOAD DivisionID,

    DivisionName

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);