where clause from qvd

[#1]

i want to use where clause from my qvd.

please let me know what is wrong in my script.

please find the attached qvd file.

[#2]

Can you send the where clause script which you are trying to apply.

[#3]

Hi abcd1234,

If you are trying to use a where clause when extracting data from a qvd then the syntax will be something like the following:

LOAD EVENT_DATE,
 AOC_SHOWED,
 AOC_REJECTED,
 AOC_OK,
 PURCHASE_FAILURE,
 PURCHASE_REVENUE,
 RENEWAL_REVENUE,
 PREMIUM_COUNT,
 CANCEL_COUNT,
 PURCHASE_COUNT,
 RENEWAL_COUNT,
 CONTENT_ID,
 CONTENT_PROFILE_ID,
 CONTENT_PROVIDER_ID,
 CHARGING_PROFILE_TYPE_ID,
 CONTENT_NAME,
 ACCOUNT_TYPE
FROM
SUMMARY.qvd
(qvd)
WHERE ACCOUNT_TYPE=2;

I hope this helps.

Rod

[#4]

Hi,

It is working fine for me.

Please check.