Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Exporting Data from a QVD File

Hi Guys,

Ok so basically i have recieved a bunch of QVD files at the end of the day these need to be automated to export into A MS SQL warehouse, is there a way to this automatically, or even if i can export it to Excel/Flat file etc i will be able to do the transformation from there.

Thanks

Tags (4)
1 Reply
fosuzuki
Valued Contributor II

Re: Exporting Data from a QVD File

You can load the QVDs, do the transformation and store them into text files as CSV.

mytable:

LOAD  *

FROM myfile1.qvd (qvd);

store mytable into myfile2.txt (txt);

Community Browser