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

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

LOAD program_name as requested_category_name,

     cip as cip_code,

     award_level

FROM

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

LOAD lead_id,

     census_geoid

FROM

(qvd);

Store lambda_binary into lambda_binary.QVD (QVD);

[Anonymous · Accepted solution]

You need to join the red tables to the green one:

LEFT JOIN (lambda_binary) LOAD program_name as requested_category_name,

   ...

FROM

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

LEFT JOIN (lambda_binary) LOAD lead_id,

...

[Clever_Anjos]

No, one QVD is relative to only one table.

Maybe you could use a qvw and binary load to import a whole datamodel

[Anonymous]

You're right.   I'm just trying to read between the lines...

[zach_paz]

Thank you both for your help. I use Michael Solomovich suggestion to JOIN the tables.