4 Replies Latest reply: Nov 6, 2013 4:30 PM by Zach Paz RSS

    Creating one QVD from multiple table files/data model

    Zach Paz

      Is it possible to create one QVD with multiple data files?

       

      I am using the following load script, but need the QVD to include all table files. Right now it only includes what is green, but i also need what is in red.

       

      Script:

       

      lambda_binary:

      LOAD lead_id,

           inquiry_date,

           zip_code,

           grad_hs_year,

           requested_category_name,

           reqeusted_degree_name, 

           text('lambda') as datapartner

          

      FROM

      [C:\Users\Zach\Documents\InquiryData\Lambda\Raw Files\GrayDataPull_20131009.txt]

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

       

      LOAD program_name as requested_category_name,

           cip as cip_code,

           award_level

       

      FROM

      [C:\Users\Zach\Documents\InquiryData\CIP Table\cip_table_v5.txt]

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

       

      LOAD lead_id,

           census_geoid

      FROM

      [C:\Users\Zach\Documents\InquiryData\Lambda\Raw Files\lambda_geocoded.QVD]

      (qvd);

       

      Store lambda_binary into lambda_binary.QVD (QVD);