Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

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

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
Creator III
Creator III

Re: how to create qvd from sql server

Thanks a lot!!

Highlighted
Creator II
Creator II

Re: how to create qvd from sql server

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

Highlighted
Creator III
Creator III

Re: how to create qvd from sql server

I think I did already