Save csv file

[livio218526]

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:

Can you help me, thanks.

[agigliotti · Accepted solution]

try using:

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

[livio218526]

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]

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

[Anonymous]

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]

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

[livio218526]

In which way?? I'm sorry

[shraddha_g]

Qlik Community Tip: Marking Replies as Correct or Helpful