QVD File Setup Data

[#1]

Hello,

I was curious to know, the QVD file created does it hold the data for one or many query with the block or just a single query.

Example

LOADQVD:

SQL < Statement Table 1>

SQL < Statement Table 2>

SQL < Statement Table 3>

store LOADQVD into ;

based on above example. will my qvd file hold all the 3 statement data or only for the Table 1 ?

I am testing this. but due to slow system adn data process I am not able to test and posting the query to community for quick update.

Thanks

[qlikmsg4u]

QVD holds only one Table (If those tables has joins and it ultimately forms one table.)

In your case it just holds table1, if there is no auto concatenation

[#3]

Yeah, I dont have joins in my script. I want to load all the data. So based on your update. I should create 3 diff QVD files. In future if  I am going to have incremental load than it should be done for all the qvd. Am I right ?

but is this right to have single query for single qvd. What if I am going to have more than 15 table load. I should build same count of QVD files ?

[Kushal_Chawda]

First, if all your SQL statement has same field names and same number of fields  then it will store the data from all SQL statements( as it will be a single table due to autoconcatenate in QlikView).

Second, if your SQL statements are independent (no relation ships with each other) then it will store only first SQL statement.

[qlikmsg4u]

If you have no joins in your script and fields are not similar it create one QVD in your case.

To create 3 QVD's do the following

LOADQVD:

SQL < Statement Table 1>

store LOADQVD into ;

LOADQVD1:

SQL < Statement Table 2>

store LOADQVD1 into ;

LOADQVD2:

SQL < Statement Table 3>

store LOADQVD2 into ;

but is this right to have single query for single qvd. What if I am going to have more than 15 table load. I should build same count of QVD files ?

That all depends on how you build your data model ..