Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD Creation - best approach?

Hello -


I have a bunch of flat files that I want to turn into invidual QVD's.  I understand how to turn them into the QVD's but what I'm having trouble with is getting them to not join up on the common fields.  I know about the qualify function which is great but I don't want my QVD's to be qualified so when the developer(s) hit them they don't see the qulified versions, so I need to unqualify them?  I could build 1 application per file but that would be cumbersome and I would think there's a better way?

table_1.txt ==> table_1.qvd

table_2.txt ==> table_2.qvd

table_3.txt ==> table_3.qvd

//using the qualify function to prevent synthetic keys from being created

QUALIFY*;

TABLE_1:

LOAD

     COL1,

     COL2,

     COL3

FROM

Data\TABLE_1.txt

(txt, codepage is 1252, embedded labels, delimiter is '~', msq);

//store QVD data into QVD File

STORE TABLE1 INTO TABLE_1.QVD;

So how do I take the above script and have it output a unqualified QVD that doesn't try to generate syntetic keys on the rest of the files being loaded?

Thanks!

4 Replies
Not applicable
Author

You don't have to worry about the synthetic keys when you're storing the data into QVDs, they won't be generated until the very end of the document reload.

So go ahead and have each file extracted into QVD within the same application.

tobias_klett
Partner - Creator II
Partner - Creator II

Hi td3wiremn,
if you don't need the tables in qvw-file and your goal is to create qvds out of txt files you could even loop over all the files like this:

For each vTableName in 'Table1', 'Table2', 'Table3'

    $(vTableName):

        Load * From $(vTableName).txt

        (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

    Store $(vTableName) into $(vTableName).qvd (qvd);

    Drop Table $(vTableName);

Next

The filelist for the loop could also be dynamically created via the filelist() function.

Hope this helps
Tobias

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

I had created a video tutorials (2 parts) on generating the QVD files. Here is the link to my blog:

http://qlikshare.com/430

I hope this helps! Happy learning.

Cheers,

DV

www.QlikShare.com

qlikviewforum
Creator II
Creator II

Hi Deepak,

Please help me out here! It is little urgent!

http://community.qlik.com/message/321197#321197


Thanks,

Attitude