i have a problem hoping u can help.i loaded 3millions of rows data to a qvd.but i have to chang data in script.the data is based on rows and i need to pivot it in sql.i can do it easily ins sql when workinf with a data databased but i can not do it the same action in qlikview script.besides this i have to lots of when case in query.i couldn't do it in qlikview script.for this reason i want to load the data in qvd to a database.but in both oracle and ms sql, i couldn't do it from qvd.thats why i have to convert qvd to text or smth like this that can enable loading format to databese.
You could enable "Open Databases in Read and Write mode" on the Settings tab in the load script editor. This will allow you to use insert statements with the SQL keyword. However, this approach would be very slow as ODBC inserts execute one statement for each row of data.
I would recommend storing the table in a text file (see below) and then using your DB's bulk loading utility.
