Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

how to create qvd from sql server

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 ?

1 Solution

Accepted Solutions
Highlighted

Re: how to create qvd from sql server

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.

View solution in original post

4 Replies
Highlighted

Re: how to create qvd from sql server

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.

View solution in original post

Highlighted
Contributor III

Re: how to create qvd from sql server

Thanks a lot!!

Highlighted
Contributor II

Re: how to create qvd from sql server

Hi, It helps and encourages the people if you tag it as answered

Highlighted
Contributor III

Re: how to create qvd from sql server

I think I did already