in my script, I store a table as a txt file for specific days. This works fine. is it possible to store as an excel file from within the script. I have tried and the files is saved to the specif directory, but I can not open it. Error - file or extention is not valid. I am not to sure whta the extention should be.
QlikView only allows you to store QVD and TXT files. The extension you want to use is irrelvant, though, meaning that you can store a TXT file with a XLS extension. Obviously, Excel will likely not recognize the file format, therefore showing an error.
// This will work, although you will need to right click to open the file
STORE Table INTO File.ZZZ (TXT);
// This will work too, and will open fine
STORE Table INTO File.csv (TXT);
Usually saving as TXT but ending the file with CSV allows you to open with Excel, but it will depend on the application by default to open CSV files.
QlikView only allows you to store QVD and TXT files. The extension you want to use is irrelvant, though, meaning that you can store a TXT file with a XLS extension. Obviously, Excel will likely not recognize the file format, therefore showing an error.
// This will work, although you will need to right click to open the file
STORE Table INTO File.ZZZ (TXT);
// This will work too, and will open fine
STORE Table INTO File.csv (TXT);
Usually saving as TXT but ending the file with CSV allows you to open with Excel, but it will depend on the application by default to open CSV files.
.png "Miguel_Angel_Baeyens"){kind=avatar}
