Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

Mapping Table with data from qvd error

Hello all, 

 

so I am slow and steady into creating my very first qvd files. I've created them but now I want to map some columns from a table I have created a qvd for.

I have something like:

 

MapName:
Mapping Load
id,name;
SQL select * from [$(vPathQVD)city_name.qvd](qvd);

 

 

During load script, I get this error :

 

The following error occurred:
There is no open data connection.
 
The error occurred here:
SQL select * from [lib://blahblahpath/city_name.qvd](qvd);
 
 
---
 
What's that about? Any ideas?
 
 
Thank you,
Ioanna.
1 Solution

Accepted Solutions
ioannagr
Creator III
Creator III
Author

For anyone with the same error, I found the solution,

MapName:
Mapping Load
id,name;
SQL select * from [$(vPathQVD)city_name.qvd](qvd);

 

should be :

MapName:
Mapping Load
id,name
from [$(vPathQVD)city_name.qvd](qvd);

 

View solution in original post

1 Reply
ioannagr
Creator III
Creator III
Author

For anyone with the same error, I found the solution,

MapName:
Mapping Load
id,name;
SQL select * from [$(vPathQVD)city_name.qvd](qvd);

 

should be :

MapName:
Mapping Load
id,name
from [$(vPathQVD)city_name.qvd](qvd);