9 Replies Latest reply: Nov 5, 2017 3:23 AM by Daniela Becerra RSS

    Mapping Load

    Daniela Becerra

      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.

        • Re: Mapping Load
          Anand Chouhan

          Can You share your load script.

            • Re: Mapping Load
              Daniela Becerra

              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 [C:\Qlikview\POCs\Ropa_Deportiva\DataSources\Employees.xls]

              (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 [C:\Qlikview\POCs\Ropa_Deportiva\DataSources\Employees_New.csv]

              (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 [C:\Qlikview\POCs\Ropa_Deportiva\DataSources\QWT_Outsourced_Staff.xls]

              (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 [C:\Qlikview\POCs\Ropa_Deportiva\DataSources\Sales_Objectives.xls]

              (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 [C:\Qlikview\POCs\Ropa_Deportiva\DataSources\Suppliers.xml] (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;