SQL Load

hkg_qlik — Fri, 15 Jun 2012 16:25:50 GMT

Hi,

I am trying to create a QVD file through a SQL statement. But its giving an error that table not found.

Message_Log1:

SQL Select PersonID, Count((convert(varchar(10),[CreateDate],111)) )

From dbo.Message

Where ActivityType=8 AND

convert(varchar(10),[CreateDate],111) >= '2011/01/01'

Group by PersonID, convert(varchar(10),[CreateDate],111);

Store Message_Log1 into \\Portal QVD Data\Message_Log1.qvd;

Drop Table Message_Log1;

Thanks,

Re: SQL Load

Fri, 15 Jun 2012 16:46:15 GMT

First test the SQL statement syntax is correct.

Second try to store the qvd locally in a path like c:/

Your problem looks like the table hasnt been loaded into qlikview before the store statement.