Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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);