Exporting data from qlikview to csv file

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[blaise]

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.

[#5]

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.