Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hkg_qlik
Contributor III

SQL Load

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,

H

1 Reply
Not applicable

Re: SQL Load

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.