topic Re: QVD File Setup Data in QlikView

QVD File Setup Data

Thu, 16 Jul 2015 05:21:27 GMT

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

Re: QVD File Setup Data

qlikmsg4u — Thu, 16 Jul 2015 05:26:42 GMT

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

Re: QVD File Setup Data

Thu, 16 Jul 2015 05:46:59 GMT

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 ?

Re: QVD File Setup Data

Kushal_Chawda — Thu, 16 Jul 2015 05:49:38 GMT

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.

Re: QVD File Setup Data

qlikmsg4u — Thu, 16 Jul 2015 05:55:40 GMT

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