Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

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
Honored Contributor II

Re: Save csv file

try using:

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

7 Replies
agigliotti
Honored Contributor II

Re: Save csv file

try using:

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

livio218526
Contributor

Re: Save csv file

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
Honored Contributor II

Re: Save csv file

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

Re: Save csv file

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
Honored Contributor II

Re: Save csv file

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

livio218526
Contributor

Re: Save csv file

In which way?? I'm sorry

shraddha_g
Honored Contributor III

Re: Save csv file