topic Re: Create a QVD instead of SQL-table and store the data in QVD in QlikView

Create a QVD instead of SQL-table and store the data in QVD

Sun, 21 Jun 2015 03:50:55 GMT

I am creating temp tables in SQL for many reasons. Is it possible to create same tables as QVD and store as QVD? Here I would like to create QVD called 'tmpProductCustomer1'. Thanks for your help.

/////////////////Sample query I am using////////////

create table tmpProductCustomer1 (

CustomerID int ,

ProductID int ,

ProductName varchar (50)

)

insert into tmpProductCustomer1

select c .CustomerID, p.productID ,p. ProductName from Customers c, Products p

/////////////////////////////////////////////////////////////////

Re: Create a QVD instead of SQL-table and store the data in QVD

swarup_malli — Sun, 21 Jun 2015 04:04:53 GMT

Do you mean you want want to create your own data in qlikview then then store them into qvds? Yes you can using Inline function

or you want pull temp table present in sql db then convert them into qvds? Yes you can

Re: Create a QVD instead of SQL-table and store the data in QVD

Sun, 21 Jun 2015 04:09:23 GMT

1st option. I want to get my data from sql tables and create temp table in Qlikview and store as QVD. (by that I can avoid create temp table in SQL). Is it Inline is the best option here?

Re: Create a QVD instead of SQL-table and store the data in QVD

swarup_malli — Sun, 21 Jun 2015 04:18:30 GMT

You can create you own data using INLINE function which involves lot of typing :- )

You can also create qvd's from views

or you could do something like this

you could run a query against the tables present in the DB, then export the result into excel .Use that excel( You could convert it into QVD for better performace ) as your source

Re: Create a QVD instead of SQL-table and store the data in QVD

Sun, 21 Jun 2015 04:34:19 GMT

Hi,

You can create QVDs directly for temp tables in qlikview without creating them in SQL. First connect to database using ODBC or OLEDB interface. Then the following syntax would work.

tmpProductCustomer1:

load CustomerID,

ProductID,

Productname;

sql select CustomerID,ProductID,Productname from customer;

store * into tmpProductCustomer1.qvd(qvd);

Here we are using preceding load to get the data from SQL to Qlikview and 'Store' function to further save data into QVDs.

Re: Create a QVD instead of SQL-table and store the data in QVD

nagaiank — Sun, 21 Jun 2015 05:07:02 GMT

You may use the following script to create the QVD,

Temp:

Load CustomerID, productID, ProductName;

SQL select c .CustomerID, p.productID ,p. ProductName from Customers c, Products p;

Store temp into tmpProductCustomer1.qvd (qvd);

Drop Table Temp;

Re: Create a QVD instead of SQL-table and store the data in QVD

Kushal_Chawda — Sun, 21 Jun 2015 07:16:48 GMT

As you are creating the temp tables using below query you can directly run this query and store the data into the qvd

Data:

select c .CustomerID, p.productID ,p. ProductName from Customers c, Products p;

Store Data into Path\TempTable.qvd;

drop table Data;

Re: Create a QVD instead of SQL-table and store the data in QVD

pratap6699 — Sun, 21 Jun 2015 20:00:28 GMT

tmpProductCustomer1 :

LOAD * INLINE [

F1, F2, F3

CustomerID, ProductID , ProductName

1, 01, iron

];

STORE tmpProductCustomer1 into sampleqvd.qvd(qvd);

Re: Create a QVD instead of SQL-table and store the data in QVD

jagan — Mon, 22 Jun 2015 02:02:26 GMT

Hi Murali,

You can create the QVD from select query by using STORE command, please find below the sample script

Data:

select c .CustomerID, p.productID ,p. ProductName from Customers c, Products p;n.

STORE Data FROM QVDFileName.qvd;

Hope this helps you.

Regards,

Jagan.