Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, guys,
I have a qvw, having several tables, linked and non-linked. I would like to have a qvd having all of those tables.
Any idea how to do that?
Thx.
For storing many tables in a single qvd you have to join all of them first. You can not store several tables into one single qvd.
Hope that helps.
Luis.
This is very unusual since a QVD stores one table, Theoretically you could concatenate all tables into one resulting table. By adding a column TableName you could distinguish the records later. But this is very uncommen and not best practice..
To store all the different tables and their associations you will either need to use multiple QVDs or simply store within a QVW file. You can then load from this one data mart QVW into other QVW's by performing a Binary Load.
To do a binary load use the QlikView File button in the Edit Script dialog.
Note that the resulting script code that is placed as the first line of your load script must stay the very first line. Also, you can not chose to only load some of the data model - it has to be the whole lot. You can however DROP some tables after the Binary Load has completed.
Hope that helps.
Steve
I agree with Steve. If it has to be all in one file it is better to do a Binary Load.
Also, this way, you maintain the data model and it loads faster.
Hi you can create a single QVD from a single QVW with mutiple tables,
its better to have linked tables rather than non linked,because it causes problems
later when qvd is loaded.
Try to join or concetenate all tables linked to non linked tables.
and store using store command for creating QVD
Another best practice is using Binary load (as advised by steve)