topic Re: qvd in QlikView

qvd

Sun, 10 Aug 2014 09:38:31 GMT

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

Re: qvd

ashfaq_haseeb — Sun, 10 Aug 2014 10:00:22 GMT

Have a look at Expressor Desktop & Server

Regards

ASHFAQ

Re: qvd

Sun, 10 Aug 2014 10:03:47 GMT

Why would you want that?

Is this part of any client request?

Moreover, Qlikview is not meant for core ETL stuff.

Re: qvd

Joseph_Musekura — Sun, 10 Aug 2014 12:14:37 GMT

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

Re: qvd

jagan — Sun, 10 Aug 2014 14:24:17 GMT

Hi Anil,

Try this link

Inserting records into Database using Qlikview Script

Hope it helps you.

Regards,

Jagan.

Re: qvd

Sun, 10 Aug 2014 17:03:58 GMT

it shows unauthorized access

Re: qvd

jagan — Sun, 10 Aug 2014 17:08:01 GMT

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.

Re: qvd

Tue, 19 Aug 2014 18:45:43 GMT

HI jagan

plz share qvw and excel file.

I'm using oracle

Re: qvd

Tue, 19 Aug 2014 18:47:20 GMT

PLz share qvw and excel file

I'm using oracle

Re: qvd

jagan — Wed, 20 Aug 2014 01:24:50 GMT

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.

Re: qvd

engishfaque — Wed, 20 Aug 2014 05:40:38 GMT

Dear Anil,

Please go through to this link,

Export data from QVD file to EXCEL file

Kind regards,

Ishfaque Ahmed

Re: qvd

engishfaque — Wed, 20 Aug 2014 06:01:52 GMT

Dear Anil,

You can do it by tricky way. Here is the way just follow.

Step 1:

Button Properties > Actions > Add > Select External > Select Export > OK > Setup > Select qvd Fields > Add > Export to "File" > Browse Location > Type File Name with Excel Extension "test.xls" > Save > OK.

Step 2:

Go to the file location and remove the last file extension.

Example:

"test.xls.qvo" to "test.xls"

Kind regards,

Ishfaque Ahmed

Re: qvd

ashfaq_haseeb — Wed, 20 Aug 2014 06:05:42 GMT

Hi Ishfaq,

Its not about storing to Excel.

Its all about storing from qvd to database.

Regards

ASHFAQ