How to get the table name of qlikview file?

[#1]

hey friends,

i want to save my qlikview data in a csv file using script. problem is that i dont know how to get the qlikview data table name to use in the script. Can anybody help me on this? Is possible can anybody write the code to store the data to external file.?

[wizardo · Accepted solution]

Hi,

im not sure exactly what you need.....

qlikview internl table names are automaticly generating from the table/file name (without path or extensions) that is in the load/select statement FROM clause.

it is posible to name a table by prefixing the load/select table with a LABEL ending with a colon " : "

this make qlikview name the table with what ever is in the lable instead of taking it from the FROM clause.

so for example if you have this load statement:

LOAD

*

FROM ;

the name of the table will be: myfilename

if you use this format:

TEXTFILE:

LOAD

*

FROM ;

the name of the table will be: TEXTFILE

later on in the script you can also use the rename table option

like this

Rename table myfilename toTEXTFILE ;

hope it helps

Mansyno