topic Exporting data from qlikview to csv file in QlikView

Exporting data from qlikview to csv file

Wed, 11 Nov 2009 16:43:42 GMT

Hi,

I was wondering if this is possible as I would like to be able to export the data from the tables in QlikView into a CSV file so I can load it to a database.

Cheers,

David

Exporting data from qlikview to csv file

Wed, 11 Nov 2009 17:21:51 GMT

Hi David,

You can right click on the tables and then go to Export ..

Then u can choose the location and file type as .csv from the 'Save As' window.

Hope this helps .

Regards,

Poorva

Exporting data from qlikview to csv file

Wed, 11 Nov 2009 17:35:30 GMT

Hi See this link ..This will help you if your trying to export using the script

http://community.qlik.com/forums/p/16564/64684.aspx#64684

Exporting data from qlikview to csv file

blaise — Thu, 12 Nov 2009 06:01:02 GMT

If you are using Qv <9 i would recommend doing it by a sql insert command in the script.

If you are using Qv9 it depends on the amount data to be loaded into the db. If the data is small, lets say <10 000 rows and only a few fields, i would go for the sql insert. If the data is bigger i would use the store table into table.csv (txt); command in the script (and after that load the csv into the db with an external tool.

The sql insert command needs to be looped, thats why it depends on the amount of data (more the number of rows because you need to loop through all the loops.

Exporting data from qlikview to csv file

Thu, 14 Jan 2010 21:37:00 GMT

blaise, I'm new to qv, plus I do not speak English, so badly written apology. Well, it can give an example of what they indicate? on sql insert

gracias.