Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
zach_paz
New Contributor II

Creating one QVD from multiple table files/data model

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

Tags (3)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

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,

...

4 Replies
mov
Esteemed Contributor III

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

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,

...

Employee
Employee

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

No, one QVD is relative to only one table.

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

mov
Esteemed Contributor III

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

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

zach_paz
New Contributor II

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

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

Community Browser