Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
Hi,
I had created a video tutorials (2 parts) on generating the QVD files. Here is the link to my blog:
I hope this helps! Happy learning.
Cheers,
DV
Hi Deepak,
Please help me out here! It is little urgent!
http://community.qlik.com/message/321197#321197
Thanks,
Attitude