topic Re: File extentions in QlikView

File extentions

kamielrajaram — Tue, 29 May 2012 08:34:59 GMT

Good day all,

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.

Thank you in advance

Kamiel

Re: File extentions

Miguel_Angel_Baeyens — Tue, 29 May 2012 11:51:21 GMT

Hi Kamiel,

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.

Hope that helps.

Miguel

File extentions

kamielrajaram — Tue, 29 May 2012 13:30:50 GMT

Thank you Miguel,

The second option worked for me.

Regards

Kamiel