topic QVD Where Clause Error in QlikView

QVD Where Clause Error

Tue, 21 Feb 2012 07:56:11 GMT

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 — Tue, 21 Feb 2012 07:59:16 GMT

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.

Tue, 21 Feb 2012 08:00:06 GMT

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