topic Re: Creating one QVD from multiple table files/data model in QlikView

Creating one QVD from multiple table files/data model

zach_paz — Wed, 30 Oct 2013 18:48:02 GMT

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);

Re: Creating one QVD from multiple table files/data model

Anonymous — Wed, 30 Oct 2013 18:52:34 GMT

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,

...

Re: Creating one QVD from multiple table files/data model

Clever_Anjos — Wed, 30 Oct 2013 18:52:53 GMT

No, one QVD is relative to only one table.

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

Re: Creating one QVD from multiple table files/data model

Anonymous — Wed, 30 Oct 2013 18:54:34 GMT

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

Re: Creating one QVD from multiple table files/data model

zach_paz — Wed, 06 Nov 2013 21:30:50 GMT

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