Discussion Board for collaboration on QlikView Scripting.
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?
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
sql select * from.....
ctrl+T will give u the ur table names and filed names.
Re: Store csv into qvd
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
from CSV ;
STORE Table1 as History.qvd(QVD);// you can define you own name for the QVD