Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

Save csv file

Hi Everyone,

I'd like to save a file in format .csv with ";" like delimitator,

I'm using this function:

store PRODUCT FROM TEST_ETL01 into 'lib://Folder/St_External_Data.csv';

But the file contains a xml code instead of a table, as you can see in the picture:

Capture.JPG

Can you help me, thanks.

1 Solution

Accepted Solutions
agigliotti
Partner
Partner

try using:

store PRODUCT FROM TEST_ETL01 into 'lib://Folder/St_External_Data.csv' (txt,delimiter is ';');

View solution in original post

7 Replies
agigliotti
Partner
Partner

try using:

store PRODUCT FROM TEST_ETL01 into 'lib://Folder/St_External_Data.csv' (txt,delimiter is ';');

livio218526
Creator
Creator
Author

Yes, it's correct. Thanks a lot.

Another questions, if i want save a qvf file instead of csv? Because if I save a qvd file i'm not able to open it with Qlik Sense.

Thanks

agigliotti
Partner
Partner

I'm sorry I don't understand your question.

bill_markham
Champion III
Champion III

After saving a qvd file using a qvf qvd generator, you can then load the qvd into a qvf dashboard.

This is a powerful technique and it is mandatory if one needs to do an incremental data load.

It is also very good to have a qvd layer, so data extracts for qvd loads are only done once giving less source database load and a single version of the truth, The qvd's can then be loaded into multiple qvf dashboards with different viz requirements

agigliotti
Partner
Partner

please mark the Correct Answer if you think your question has been answered.

livio218526
Creator
Creator
Author

In which way?? I'm sorry