Export table to .csv using STORE command in script

[yanivbm88]

Hi,

My goal is to export a full table to .csv file. In addition, I want to add a delimiter which I determine.

I understood the best/easiest way to do so in Qlik Sense is by using STORE command in the script. No need for VBA macros.

Does anybody have suggestions for the exact syntax?

Thanks!

[thevingo]

STORE TableName into C:\Path\TableName.csv(txt);

[yanivbm88]

Hi Govind,

Tried your suggestion, I get the following error:

This statement only works with lib:// paths in this script mode

[thevingo]

My mistake, QS work on libraries

try

STORE TableName into TableName.csv(txt); //I think this will store in same folder where your app is stored.

[avinashelite]

In Qliksense for any folder you need add an connection/lib path for that ...go to edit script > to the right you will see an option folder > select and add the desired folder location then while storing use the connection name for it or simply the lib path its will store automatically

Hope this helps you

[yanivbm88]

Hi Govind,

Unfortunately, still no success. See error below (In the script I have a semicolon at the end of the phrase).

I also tried the following syntax without success:

Store * From DimKanban into testcsv.csv(txt);

Error here:

No qualified path for file: ***

The error occurred here:

Store DimKanban into testcsv.csv(txt)

[yanivbm88]

Hi Avinash,

Actually, I tried this before and indeed a CSV file was generated. However, it's format is very strange.

I also tried exporting to a .txt file

I attach the files for your reference.

[yanivbm88]

Second file

[avinashelite]

Could you share the complete script please ? I suspect the data is been converted to XML format that is the reason your getting this output

[JustinDallas]

Have you tried giving it a fully qualified path name?  Like C:\SomeDir\SomeOtherDir\testcsv.csv(txt)