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!