topic Re: Importing QVD in SQL in QlikView

Importing QVD in SQL

Wed, 17 Sep 2014 04:40:51 GMT

Dear All,

I know QVD can be read by qlikview only but is there are any way to load data from qvd in SQL server..

I need to check ka data available in QVD..

Rahul

Re: Importing QVD in SQL

jagan — Wed, 17 Sep 2014 04:52:54 GMT

Hi,

Try like this to import QVD data to SQL

//Connection Sring

ODBC Connect to trDatabase;

//Load Data from Excel file

TABLE:

LOAD transaction_date,

location,

item,

site

FROM

[Data.qvd]

(qvd);

// 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;

Hope this helps you.

Regards,

Jagan.

Re: Importing QVD in SQL

nikhilgarg — Wed, 17 Sep 2014 05:42:21 GMT

HEy,

But if i ask that say i have a excel file on desktop and i load it and converted to .qvd file .

NOw i want to load .qvd data into another empty and new excel file on desktop.

How can i do it.

Please hep.

Thanks.

Re: Importing QVD in SQL

jagan — Wed, 17 Sep 2014 05:44:52 GMT

Hi,

If CSV file is ok then use STORE command like below

TableName:

LOAD

FROM FileName.qvd (qvd);

STORE TableName INTO FileName.csv;

Regards,

Jagan.

Re: Importing QVD in SQL

nikhilgarg — Wed, 17 Sep 2014 05:53:08 GMT

HEy,

DOes this sTORE command create a file FileNAme.csv and store the data in FileNAme.csv ??

IS it so ??

Please help.

Thanks

Re: Importing QVD in SQL

jagan — Wed, 17 Sep 2014 05:54:31 GMT

Yes.

Re: Importing QVD in SQL

ashfaq_haseeb — Wed, 17 Sep 2014 05:56:59 GMT

Hi,

have a look at this extension too.

http://community.qlik.com/docs/DOC-5970

Regards

ASHFAQ

Re: Importing QVD in SQL

nikhilgarg — Wed, 17 Sep 2014 06:02:12 GMT

HEy ,

IT does work in csv.

BUt when i tried to create excel file by changing extension to .xlsx , a file is created but it doesnot open.

What to do ??

Please tell.

Thanks.

Re: Importing QVD in SQL

ashfaq_haseeb — Wed, 17 Sep 2014 06:08:01 GMT

Hi,

Create new thread for this.

You are mixing topics

try below

STORE TableName INTO FileName.csv(txt);

Regards

ASHFAQ

Re: Importing QVD in SQL

jagan — Wed, 17 Sep 2014 06:08:07 GMT

Hi,

This won't work for Excel, instead you can open the CSV in Excel also.

Regards.

Jagan.

Re: Importing QVD in SQL

nikhilgarg — Wed, 17 Sep 2014 06:17:33 GMT

Hey,

I opened .csv in excel but no meaningful information is there in excel sheet.

How can i get data in excel sheet from a .qvd ??

Re: Importing QVD in SQL

WalTig — Fri, 11 Jan 2019 06:37:02 GMT

Well, I know this is an old thread. But for anyone who's ending up here and wants to get QVD-data in SQL: this is a way to do it:

Use the free Q-Eye Qlikview Data File Editor

Open the editor
Open the QVD-file
Make sure you don't have the default partial load (1000 records), but the full load
Save as
SQL Insert

The tool is rather slow, but will do the job