topic Re: Mapping Load and Applymap error in QlikView

Mapping Load and Applymap error

Tue, 03 Feb 2015 04:35:50 GMT

Cannot open file 'C:\Users\User\Desktop\Northwind.dbo.Customers' The system cannot find the file specified.

Customers:
MAPPING LOAD
CustomerID,
CompanyName
FROM Northwind.dbo.Customers

Hi All,

I am getting above error. Please help.

Customers:
MAPPING LOAD
CustomerID,
CompanyName
FROM Northwind.dbo.Customers;

Orders:
LOAD *,
ApplyMap('Customers', CustomerID, 'N/A') AS CompanyName
FROM Northwind.dbo.Orders;

EXIT Script;

Re: Mapping Load and Applymap error

Anonymous — Tue, 03 Feb 2015 04:38:36 GMT

There might be a problem with the connection string.

Re: Mapping Load and Applymap error

robert_mika — Tue, 03 Feb 2015 04:45:52 GMT

Go to this Folder

C:\Users\User\Desktop\Northwind.dbo.Customers

and check if your database is still there.

Re: Mapping Load and Applymap error

jonathandienst — Tue, 03 Feb 2015 06:35:44 GMT

I think you are missing the connection string to the Northwind database, so QV is assuming this is a file. Also, you will need a SQL SELECT rather than just a LOAD to retrieve data from a database.

HTH

Jonathan