Table Not Found error when storing to QVD

[#1]

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);

[brenner_martina · Accepted solution]

Hi, Phil,

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

[#3]

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.

[#4]

ha, true, sorry for my recomendation.