4 Replies Latest reply: Mar 12, 2013 10:55 PM by Rikab Kothari RSS

    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!