topic Table Not Found error when storing to QVD in QlikView

Table Not Found error when storing to QVD

Fri, 04 Feb 2011 17:33:02 GMT

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

AW:Table Not Found error when storing to QVD

brenner_martina — Fri, 04 Feb 2011 17:45:07 GMT

Hi, Phil,

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

Table Not Found error when storing to QVD

Fri, 04 Feb 2011 17:46:27 GMT

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.

Table Not Found error when storing to QVD

Fri, 04 Feb 2011 17:47:00 GMT

ha, true, sorry for my recomendation.