Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivbm88
Creator
Creator

Export table to .csv using STORE command in script

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!

22 Replies
sasiparupudi1
Master III
Master III

change

Store DimKanban into testcsv.csv(txt);

to

Store * From  DimKanban into lib://Yourfolder/testcsv.csv(txt)(txt, delimiter is ',');

yanivbm88
Creator
Creator
Author

Many thanks Harish, it worked!!

Valstar
Contributor II
Contributor II

If somebody is here >= 2024, both of the below work in qlik sense enterprise in load editor after loading the table:

Store * From yourtable into lib://Yourfolder/yourcsvname.csv(txt, delimiter is ';');

Store * From yourtable into lib://Yourfolder/yourcsvname.csv(txt, delimiter is ',');