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

[#1]

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

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

[swarup_malli]

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

[#3]

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?

[swarup_malli]

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

[#5]

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.

[nagaiank]

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;

[Kushal_Chawda]

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;

[pratap6699]

tmpProductCustomer1 :

LOAD * INLINE [

    F1, F2, F3

    CustomerID, ProductID , ProductName

    1, 01, iron

];

STORE tmpProductCustomer1  into sampleqvd.qvd(qvd);

[jagan]

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.