Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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,
...
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,
...
No, one QVD is relative to only one table.
Maybe you could use a qvw and binary load to import a whole datamodel
You're right. I'm just trying to read between the lines...
Thank you both for your help. I use Michael Solomovich suggestion to JOIN the tables.