topic Re: Mapping Load in QlikView

Mapping Load

Anonymous — Sat, 04 Nov 2017 02:44:27 GMT

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

its_anandrjs — Sat, 04 Nov 2017 18:22:56 GMT

Can You share your load script.

Re: Mapping Load

Anonymous — Sat, 04 Nov 2017 20:47:30 GMT

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;

Re: Mapping Load

Anonymous — Sat, 04 Nov 2017 21:06:27 GMT

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

its_anandrjs — Sun, 05 Nov 2017 07:01:49 GMT

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

Re: Mapping Load

Anonymous — Sun, 05 Nov 2017 08:23:10 GMT

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...

Re: Mapping Load

Anonymous — Sun, 05 Nov 2017 08:26:36 GMT

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

Re: Mapping Load

Anonymous — Sun, 05 Nov 2017 08:43:35 GMT

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);