Discussion Board for collaboration on QlikView Scripting.
I am trying to create a QVD file through a SQL statement. But its giving an error that table not found.
SQL Select PersonID, Count((convert(varchar(10),[CreateDate],111)) )
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;
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.