QVD Creation

[#1]

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

[Joaquin_Lazaro]

Hi:

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

Read QlikView online help.

Joaquin

[simondachstr · Accepted solution]

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."

[#4]

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....!

[its_anandrjs]

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

[jagannalla]

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

[Joaquin_Lazaro]

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;

[preminqlik]

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

NEXT

[nizamsha]

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

[ashwanin]

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.