Exporting large amount of data in csv format

[gauravkhare]

Hi All,

I have large amount of data say about 50 crores of records. Now I want to export all the data into csv format. Till now I'am selecting 2 years and then exporting the data into csv because exporting the whole amount of data is not quite feasible here as it creates some memory issues here. Each time I'am performing the same activity of selecting 2 consecutive years and then exporting data. Now I want to use some coding/method( macro) which will do this activity for me because as for now it takes nearly 48 hrs for this activity to get completed................

Can anyone provide me with a definite solution.......?

[erichshiino]

Hi,

There are some interesting posts that explore loops on fields.

This is one that I believe will fit in your case.

http://community.qlik.com/forums/t/26622.aspx

You need to adapt the code for your fields and to export csv instead of excel files.

You may find methods to export a chart or table on the API Guide.

but let's say that all your data is ready in the tables of the data model in the script. you could loop a field in the script, create temporary tables with where clause and export it using 'store table into file.csv (txt) ; '

Tell us if you need more instructions to implement this on your app.

Best regards,