qvd

[#1]

Hi All,

I loaded data from database into qlikview and store in qvd.

can we export the data in qvd to database(revert back) ? if it is possible Explain

Regards:

Anil

[ashfaq_haseeb]

Hi

Have a look at Expressor Desktop & Server

Regards

ASHFAQ

[#3]

Why would you want that?

Is this part of any client request?

Moreover, Qlikview is not meant for core ETL stuff.

[Joseph_Musekura]

Dear Anil,

As opposed to databases that are Transactional Processing oriented i.e. where you can delete, update, and enter new data etc..., QlikView is a read-only data retrieval system.  In QlikView, data is handled through an ETL (Extract-Transform- Load) process but QlikView in not concerned with the UPDATE, DELETE and INSERT operations rather is more interested in querying and retrieving specific sets of data for analysis.

To answer to your question, In QlikView you can well load data from your QVD, then Export those loaded data to an external file like *.csv, *.txt   etc... . And finally import them  from your database. As explained by Ashfaq, Expressor could be used as well.

But, I can’t see why you should go through this process?  What do you want to achieve by doing so?

Regards,

/jo

[jagan]

Hi Anil,

Try this link

Inserting records into Database using Qlikview Script

Hope it helps you.

Regards,

Jagan.

[#6]

it shows unauthorized access

[jagan]

Hi,

This is the sample script in that link

Hi,

The below script helps to insert data from Qlikview to Database using Script, in this we are reading data from Excel and writing to database, change excel to database in your scenario.

//Connection Sring

ODBC Connect to trDatabase;

//Load Data from Excel file

TABLE:

LOAD transaction_date,

     location,

     item,

     site

FROM

[Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

// Getting number of records in Table

LET V_ROWS = NoOfRows('TABLE');

// Loop through the records and insert into Database table

FOR V_ROW = 0 TO V_ROWS - 1

LET V_FIELD1 = Peek('transaction_date',V_ROW);

LET V_FIELD2 = Peek('location',V_ROW);

LET V_FIELD3 = Peek('item',V_ROW);

LET V_FIELD4 = Peek('site',V_ROW);

SQL INSERT INTO dbo.temp_Table(transaction_date, location,item, site) VALUES('$(V_FIELD1)','$(V_FIELD2)', '$(V_FIELD3)','$(V_FIELD4)');

NEXT;

Regards,

Jagan.

[#8]

HI jagan

plz share qvw and excel file.

I'm using oracle

[#9]

Hi

PLz share qvw and excel file

I'm using oracle

[jagan]

Hi Anil,

I don't have the Qlikview and Excel file I implemented this in one of my client project.  You just create an Excel file or inline data and try to push it to database.

Note: You also required a database table in the Database.

Please close this discussion.

Regards,

Jagan.