QVD Where Clause Error

[#1]

Hello,

I'm getting syntax error when adding where clause to the Load QVD Script.

Error Message "Cannot open file".

It works perfectly WITHOUT the where clause, so any help on the syntax below would be much appreciated!

LOAD Local_Date,

  Clicks as Network_clicks
FROM [\\sea1ts\law\imp.qvd]

WHERE local_date='2012-01-01'(qvd);

[jagan · Accepted solution]

Hi,

Try using the below script

LOAD Local_Date,

  Clicks as Network_clicks
FROM [\\sea1ts\law\imp.qvd]

(qvd)

WHERE local_date='2012-01-01';

Hope this helps you.

Regards,

jagan.

[#3]

I found out the issue.  (qvd) has to be BEFORE the where clause.

LOAD Local_Date,

  Clicks as Network_clicks
FROM [\\sea1ts\law\imp.qvd] (qvd)

WHERE Local_Date='2012-01-01';