- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mapping Load and Applymap error
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;
- Tags:
- new_to_qlikview
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There might be a problem with the connection string.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Go to this Folder
C:\Users\User\Desktop\Northwind.dbo.Customers
and check if your database is still there.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
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