Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ETL Script Store statement syntax (Store from QVW to XLS, CSV and Pipe delimited Text)

What is the ETL store statement syntax for storing data from QVW to XLS and CSV.

For example,

QVD can be created from QVW using following

store myTable into myTable.QVD(QVD);

Waht is the syntax for excel files, CSV files and Pipe delimited text files.

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

The store statement can only generate QVD or TXT files. No XLS.

the syntax for TXT files is:

store mytable into myfile.txt (txt);

Take a look at the Help, search for 'store' that you will find some more information... you can also specify the delimiter.

Regards,

Fernando

View solution in original post

3 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

The store statement can only generate QVD or TXT files. No XLS.

the syntax for TXT files is:

store mytable into myfile.txt (txt);

Take a look at the Help, search for 'store' that you will find some more information... you can also specify the delimiter.

Regards,

Fernando

Not applicable
Author

Thanks. 'QV Help' had those answers!

gruppo_cws_qvc
Partner - Contributor
Partner - Contributor

Store pippo into pippo.csv

(delimiter is ';');

It works!

You can specify the format, see guide for details...

Mark