Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator 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
rubenmarin

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
rubenmarin

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

trishita
Creator III
Creator III
Author

Thanks a lot!!

qvraj123
Creator II
Creator II

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

trishita
Creator III
Creator III
Author

I think I did already