topic Re: MySql Statement in QlikView

MySql Statement

Wed, 18 Jun 2014 17:31:27 GMT

Hi,

i need to write data from qvd into mysql database. ¿anyone know how can i do that?

Re: MySql Statement

Gysbert_Wassenaar — Wed, 18 Jun 2014 17:40:56 GMT

Load the data from the qvd file into a table in a Qlikview document
Store the table into a csv file
Import the csv file into the mysql database

Re: MySql Statement

maxgro — Wed, 18 Jun 2014 17:42:28 GMT

search in the community

write back to database

Re: MySql Statement

Wed, 18 Jun 2014 17:43:32 GMT

Hi,

Maybe if you export to excel or table file (QVD Information) and then load in MySQL this file. (Select * from MyFile.xlsx; something like this).

Best Regards.

Re: MySql Statement

Wed, 18 Jun 2014 17:45:13 GMT

thanks for your answer. Do you know if i can do that directly without plain archives?

Re: MySql Statement

Wed, 18 Jun 2014 17:45:19 GMT

thanks for your answer. Do you know if i can do that directly without plain archives?

Re: Re: MySql Statement

Clever_Anjos — Wed, 18 Jun 2014 17:59:03 GMT

You could make some logic (look below) calling inserts (or stored procedures).

I think plain files would be much better and 'cleaner'

Transactions:
Load
    Dim1,
    Dim2,
    Expression1
From yourvd.qvd(qvd);

for i = 0 to NoOfRows('Transactions')
    Let vDim1=Peek('Dim1',$(i),'Transactions');
    Let vDim2=Peek('Dim2',$(i),'Transactions');
    let vExp=Peek('Expression1',$(i),'Transactions');
    let sql='INSERT INTO <your table> values('&$(Dim1)&','&$(Dim2)&','&$(vExp)&')';
    SQL EXEC $(sql);
next

Re: MySql Statement

Wed, 18 Jun 2014 18:04:30 GMT

Hi,

Just make sure in script editor, Configuration Sheet option allow insert and update sentence is marked.

Best regards.

Re: Re: MySql Statement

Gysbert_Wassenaar — Wed, 18 Jun 2014 18:06:21 GMT

I think plain files would be much better and 'cleaner'

I agree, and pretty easy to automate and have good performance. Executing Stored Procedures one record at a time for several hundred thousand (or millions of) records is not a great idea.

Re: Re: MySql Statement

Wed, 18 Jun 2014 21:12:34 GMT

thanks for your answer, few days ago i tried to do that using a for cycle and that process was slower than plain file. I think that maybe with qlikview i can use something like sql insert or other similar sentences but all of that was ineffective. thanks for all, now i'm using an archive created from script and load data inline sentence to write in the database.