Discussion Board for collaboration on QlikView Scripting.
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.
text('lambda') as datapartner
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
LOAD program_name as requested_category_name,
cip as cip_code,
Store lambda_binary into lambda_binary.QVD (QVD);
Go to Solution.
You need to join the red tables to the green one:
LEFT JOIN (lambda_binary) LOAD program_name as requested_category_name,
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.