Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to store many tables into qvds at a time
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
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
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
Hi,
U cannot store more that one table in one qvd. U should have n QVD's to store n tables.
-Sundar
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
Hi Venu
You can use For loop to store many tables in qvd at a same time .
Regards
Rishi beri
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
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.
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
Hi,
please close this thread if there are no further questions.
Thanks
Regards
Marco