topic Re: QVD Creation in QlikView

QVD Creation

Tue, 20 May 2014 09:37:29 GMT

Hi,

1) I have tables for creating QVD's .

Table1:

Column A, Column, B...Column N

........

From......

Table2:

Col1, Col2, Col3....Col X

....

From.....

Store Table1 into Table1.qvd(qvd);

By this QVD is created for only the first table but i want to create qvd for both the tables how i can do this.

2) IF I HAVE MORE THAN TWO TABLE, I WANT TO CREATE QVD WITH MULTIPLE TABLE HOW CAN I GET.

PLEASE SOME BODY HELP ME

Re: QVD Creation

Joaquin_Lazaro — Tue, 20 May 2014 09:40:28 GMT

Hi:

One STORE for each table, all fields or named fields.

Read QlikView online help.

Joaquin

Re: QVD Creation

simondachstr — Tue, 20 May 2014 09:41:40 GMT

I quote gwassenaar's reply in another post:

"You can only store one table per qvd. You'll have to join and/or concatenate your tables into one table first if you want to store them in one qvd."

Re: QVD Creation

Tue, 20 May 2014 09:42:08 GMT

QVD can store 1 table of data at a time.

So you can't store 2 tables in 1 QVD as ur column names are different in both the tables.

Hope this will help you....!

Re: QVD Creation

its_anandrjs — Tue, 20 May 2014 09:43:27 GMT

You can write like

Table1:

From Location;

Store Table1 into Table1.qvd(qvd);

Table2:

From Location;

Store Table2 into Table1.qvd(qvd);

Table name is required and which is same with the table name used in table laod

Re: QVD Creation

jagannalla — Tue, 20 May 2014 09:44:17 GMT

Hi,

Table1:

Column A, Column, B...Column N

........

From......

Store Table1 into Table1.qvd(qvd);

drop table Table1;

Table2:

Col1, Col2, Col3....Col X

....

From.....

Store Table2 into Table2.qvd(qvd);

drop table Table2;

Thanks,

Jagan

Re: QVD Creation

Joaquin_Lazaro — Tue, 20 May 2014 09:44:21 GMT

HI:

You must create a new temp table and delete it after store.

MixedTable:

LOAD fieldA,

fieldB

Resident Table1

LEFT JOIN

LOAD fieldA,

ColumnX,

ColumnZ

Resident Table2

Store MixedTable into MixedTable.qvd(qvd);

Drop Table Mixed Table;

Re: QVD Creation

preminqlik — Tue, 20 May 2014 09:48:13 GMT

LET varRow= NoOfRows('tables');

FOR varRowNo = 0 to ($(varRow)-1)

LET varTableName=Peek('TableName',$(varRowNo),'tables');

$(varTableName):

SQL SELECT *

FROM erplndb.dbo."$(varTableName)";

STORE $(varTableName) into E:\Qlikview\Data\QVD\$(varTableName).qvd;

//DROP Table $(varTableName);

Re: QVD Creation

nizamsha — Tue, 20 May 2014 09:48:31 GMT

both the table have same column name so what qlikview will do it will auto concatenate both the table and create a single qvd for TableA;

if u want 2 qvd for 2 table mean then use no concatenate in before the second table then store both the table individually but synthetic key will occur so what u want to do is

Table1:

Column A, Column, B...Column N

........

From......

Store Table1 into Table1.qvd(qvd);

drop table Table1;

Table2:

Col1, Col2, Col3....Col X

....

From.....

Store Table2 into Table2.qvd(qvd);

Re: QVD Creation

ashwanin — Tue, 20 May 2014 09:52:46 GMT

Hi,

To create multiple qvds you have to store these seperately please do the below.

e.g

Table1:

Column A, Column, B...Column N

........

From......

Store Table1 into Table1.qvd(qvd);

Table2:

Col1, Col2, Col3....Col X

....

From.....

Store Table2 into Table2.qvd(qvd);

By this method QVD is created for all the tables.

Re: QVD Creation

Thu, 22 May 2014 12:29:52 GMT

Thanks You All, with you valuable information...