MySql Statement

[#1]

Hi,

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

[Gysbert_Wassenaar]

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

[maxgro]

search in the community

write back to database

[#4]

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.

[#5]

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

[#6]

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

[Clever_Anjos]

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

[#8]

Hi,

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

Best regards.

[Gysbert_Wassenaar]

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.

[#10]

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.