topic Re: Is it possible to export records into a CSV file using qlikview script? in QlikView

Is it possible to export records into a CSV file using qlikview script?

sasiparupudi1 — Tue, 02 Jun 2015 18:27:32 GMT

I have a situation where I am reading records from different tables and I want to write them into a CSV file. Please let me know if there is any way to achieve this?

Thanks in Advance

Sasi

Re: Is it possible to export records into a CSV file using qlikview script?

petter — Tue, 02 Jun 2015 18:34:01 GMT

You can use the STORE statement at the end of your load script:

STORE [myTable] INTO [myTable.CSV] (txt);

Re: Is it possible to export records into a CSV file using qlikview script?

ronald_gdi — Tue, 02 Jun 2015 18:37:15 GMT

In the Edit Scripts you can use this:

FOR i = 0 to NoOfTables() - 1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName)' & '_' & '$(vPeriodo).csv';

STORE [$(vTableName)] INTO [$(vOutfile)] (ansi, txt, delimiter is ';');

The script list all tables on the QVW and export a csv file.

King Regards!

Re: Is it possible to export records into a CSV file using qlikview script?

sasiparupudi1 — Tue, 02 Jun 2015 18:40:21 GMT

I do not have the data in one table. I draw fields from multiple tables based on some logic and want to create a new table with the fields in a loop but I am not able to do that.So, I thought of writing the field values into a csv file and reload it as a table. I hope I am making sense here.

Re: Is it possible to export records into a CSV file using qlikview script?

MarcoWedel — Tue, 02 Jun 2015 21:02:34 GMT

please post some sample data of your source tables and the expected resulting table.

Maybe there is no need for an export/import to achieve your intended data model.

thanks

regards

Marco

Re: Is it possible to export records into a CSV file using qlikview script?

sasiparupudi1 — Wed, 03 Jun 2015 06:45:06 GMT

Hi Ronald

Thanks for your post and I learned a new trick . But I found the answer I am actually looking for in the following post where the data in the variables are loaded into a table.

Re: Generating a inline table with last date of each month of a year

Thanks

Sasi

Re: Is it possible to export records into a CSV file using qlikview script?

ngulliver — Tue, 09 Jun 2015 15:56:27 GMT

Hi, Sasidhar.

Have a look at this short blog on exporting to CSV.

http://www.quickintelligence.co.uk/write-csv-qlikview-store/

regards,

Neil