Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks. 'QV Help' had those answers!
Store pippo into pippo.csv
(delimiter is ';');
It works!
You can specify the format, see guide for details...
Mark