PROBLEM STORING TABLE TO .CSV (FILE GENERATED TOO BIG)

_fl — Wed, 22 May 2019 10:36:44 GMT

Hi,

I need to export a table (created from a concatenation of several files) from QlikSense to .csv format.

I tried the code below:

For each file in FileList ('lib://DIRECTORY/*file_name*.xlsx')
"TABLE":
LOAD * FROM [$(file)] (ooxml, embedded labels, table is sheet1);
NEXT;

STORE "TABLE" INTO lib://DIRECTORY/file_name.csv (txt);

The problem is that the file_name.csv created is way too big compared to the input (8 excel files for a total of 50MB generate a .csv for 1600MB) and it crashes when I open it.

I tried also deleting the '(txt)' but the .csv comes out in a format I can't understand.

Thank you very much for your help!

topic PROBLEM STORING TABLE TO .CSV (FILE GENERATED TOO BIG) in App Development

PROBLEM STORING TABLE TO .CSV (FILE GENERATED TOO BIG)