topic Re: Extracting data from a table using STORE in QlikView

Extracting data from a table using STORE

cliff_clayman — Thu, 24 Mar 2016 20:02:49 GMT

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?

Re: Extracting data from a table using STORE

martinpohl — Thu, 24 Mar 2016 21:57:04 GMT

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

data:

sql select * from.....

Regards

Re: Extracting data from a table using STORE

Chanty4u — Fri, 25 Mar 2016 05:20:57 GMT

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

avinashelite — Fri, 25 Mar 2016 05:31:17 GMT

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