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 tables in CSV or SAS files

Hi Friends,

In the script editor i have created a table having some calculated variable, is it possible to export whole table from Qlikview

on any drive of my desktop?

Regards,

Gaurav

1 Solution

Accepted Solutions
MVP
MVP

Re: Exporting tables in CSV or SAS files

Gaurav

STORE [YourTableName] into [YourFileName.csv] (txt);

Make sure that the path pointed to by YourFileName does exist.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
aadilmadarveet
Valued Contributor

Re: Exporting tables in CSV or SAS files

Use the same syntax that Qlikview creates when you read in a csv or any other format for that purpose.

Something like below.

STORE tablename into D:/MyFile.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

MVP
MVP

Re: Exporting tables in CSV or SAS files

Gaurav

STORE [YourTableName] into [YourFileName.csv] (txt);

Make sure that the path pointed to by YourFileName does exist.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser