How to create an excel file during a loop and reduce reload?

[#1]

Hello,

Is it possible to create an excel file during a loop and reduce reload?

Could something like the STORE INTO script be used to create an excel files?

Thanks,

Tyler

[Miguel_Angel_Baeyens]

Hello Tyler,

You can STORE into text format (CSV) if you specify that in the STORE line:

STORE Table INTO Table.txt (txt);

This file may be read on Excel, but QlikView does not support direct export to Excel. Only, QVW and PDF if you have the appropriate license.

Hope that helps.

Miguel

[#3]

Thanks Miguel,

  If I can get 'STORE Table INTO Table.csv (txt);' to work I beleive excel will recognize it without having to import.

Will update with my script after I test.