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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Not Found error when storing to QVD

Hi Everyone, I get an error saying table nto found when using the below code to generate and store a qvd file. Where am I going wrong?

//Load drug Given By
Data DrugGivenBy:
MAPPING LOAD
givenByCode,
givenBy;
SQL SELECT *
FROM TCMPRF.dbo."LU52_GivenBy";
STORE DrugGivenBy into C:\Documents and Settings\me\My Documents\QV\DrugGivenBy.qvd (qvd);


1 Solution

Accepted Solutions
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi, Phil,

the "Mapping" is wrong, use only Load. Mapping tables will only work together with ApplyMap-function!

View solution in original post

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi, Phil,

the "Mapping" is wrong, use only Load. Mapping tables will only work together with ApplyMap-function!

Not applicable
Author

Hi,

when you name a table you must remember that you can't use spaces or if you do you must enclose the name in brackets [Data DrugGivenBy] , so your table must be recall with the complete name in brackets.

Not applicable
Author

ha, true, sorry for my recomendation.