Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

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
Partner - Master
Partner - Master

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
MVP
MVP

chk dis

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

Re: Store csv into qvd

avinashelite

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