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.
cliff_clayman
Contributor

Extracting data from a table using STORE

I would like to be able to extract the data from a table into a CSV file using the STORE command in the script.  However, I'm not sure what the name of the table is.  How can I find out the table name?

3 Replies
martinpohl
Valued Contributor II

Re: Extracting data from a table using STORE

for store you can use

store tablename into filename.csv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

the tablename you can find in the table viewer (ctrl + t) after reload the script

from files it is the filename, from excel-sheets the sheetname with prefix $, from data bases the table name maybe with prefix of database content (msd.country)

you can also give your own table name in the script with the table label and a ":" before your load or select statement

data:

load.....

or

data:

sql select * from.....

Regards

Chanty4u
Esteemed Contributor III

Re: Extracting data from a table using STORE

chk dis

ctrl+T  will give u the  ur table names and filed names.

Re: Store csv into qvd

Re: Extracting data from a table using STORE

Does your CSV have the table names ??? if not then you need to define the custom table names for the same , so that you can use this while storing the tables as QVD's

Table1: //custom name

LOAD *

from CSV ;

STORE Table1 as History.qvd(QVD);// you can define you own name for the QVD

Community Browser