how to store many tables into qvds at a time

[#1]

how to store many tables into qvds at a time

[robert99]

Unsure what you mean

But you can run one .QVW file and create more than one  .qvd file

But only one table in one qvd file 

[rbecher]

Theoretically, you can LOAD (concatenated) several different tables into one QlikView table (maybe use an additiona field as table descriptor) and then store all together into one QVD file. One QVD file stores one table, only.

But, I don't know if this is the wanted solution..

- Ralf

[sundarakumar]

Hi,

U cannot store more that one table in one qvd. U should have n QVD's to store n tables.

-Sundar

[ashfaq_haseeb]

Hi,

Qvd storage works as 1 table per qvd.

But you can have several table joined together to form 1 single table and you can store this result( generated from multiple joins or concatenate) into 1 single qvd.

Regards

ASHFAQ

[#6]

Hi Venu

You can use For loop to store many tables in qvd at a same time .

Regards

Rishi beri

[MarcoWedel · Accepted solution]

As this thread is titled "... into qvds ... ", I guess this might be solution, venu gopal was looking for.

One possible implementation.:

FOR i = 0 to NoOfTables()-1
LET vTabNam = TableName($(i));
STORE $(vTabNam) into $(vTabNam).qvd (qvd);
NEXT i

hope this helps

regards

Marco

[jagan]

Hi,

You can stored only one table in a QVD file, if you want to store multiple tables then you have store it in multiple QVD files.  You can store in QVD files using like this

STORE Table1 INTO Table1.qvd;

STORE Table2 INTO Table2.qvd;

STORE Table3 INTO Table3.qvd;

'

'

'

'

STORE Tablen INTO Tablen.qvd;

Or you can use For loop to store all tables in QVDs like below

FOR vCount = 0 to NoOfTables()-1

     LET vTableName = TableName($(vCount));

     STORE $(vTableName ) INTO $(vTableName).qvd (qvd);

NEXT vCount

Regards,

Jagan.

[sarvjeet]

Hi Venu,

Answer to you question is "NO" .

You can store Multiple table in QlikMarts. QlikMarts are qvw's that contains script that loads the data into a standard QV star schema. Presentation QVWs then can load them with the BINARY script statement.

-Sarvjeet

[MarcoWedel]

Hi,

please close this thread if there are no further questions.

Thanks

Regards

Marco