topic Re: how to create qvd from sql server in QlikView

how to create qvd from sql server

trishita — Wed, 02 May 2018 11:06:32 GMT

I have access to sql server:

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

I am trying to load the view into qvd form.How can I convert into a load statement ?

rubenmarin — Wed, 02 May 2018 11:08:26 GMT

Hi Trishita, I think you only need:

TableName:

LOAD *;

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

STORE TableName into TableName.qvd(qvd);

DROP Table TableName; // Optional, if you want to delete the laoded table in QV.

trishita — Thu, 03 May 2018 11:26:28 GMT

Thanks a lot!!