Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 - Champion
Partner - Champion

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 - Champion
Partner - Champion

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 - Champion
Partner - Champion

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

Anonymous
Not applicable

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 - Champion
Partner - Champion

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

livio218526
Creator
Creator
Author

In which way?? I'm sorry