topic Re: saving data on drive in script in QlikView

saving data on drive in script

Fri, 26 Apr 2013 15:03:50 GMT

Hi All

as we import data from drives in to qvw like

load * from table

can we export data from qvw in the script on to excel saved on shared drives

can you please share syntax

thanks

Fri, 26 Apr 2013 15:29:56 GMT

Hi ,

You can store the file in CSV format\

Store tablename into filename.csv (txt) ;

Mon, 29 Apr 2013 11:34:44 GMT

so that means i can't save in existing xls file via script?

Mon, 29 Apr 2013 12:27:00 GMT

tab:

load *

from tablename;

store tab into D:\test.qvd;

store tab into D:\test1.xlsx;

Mon, 29 Apr 2013 12:44:27 GMT

Hi,

Yes,you can save in existing xls file via script.

use the syntax:

Store tablename into filename.xls;

Regards,

Snehal Nabar