topic Re: How to create multiple table to one QVD in QlikView

How to create multiple table to one QVD

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I am facing one issue i.e. i have two tables one table is from database having seven columns. another table is from spreadsheet having 10 columns. i am sharing sample excel file. under this file in database sheet i have name column having 10 records. another sheet Table1 name column having 5 records. So my requirement is in Table1 records are having 5 so i want to create a One qvd from these two tables with 5 records data. can anyone help me on this how to achieve.

Re: How to create multiple table to one QVD

simrankaur — Tue, 05 Nov 2019 09:31:25 GMT

Database:

load * from database;

Table:

Load * from Table 1;

noconcatenate

Final:

load Name,Owner resident table1;

left join

load Name,ID,Status Resident Database;

By this, you will get the desired output as shown according to your excel.

Re: How to create multiple table to one QVD

shabarish0587 — Tue, 05 Nov 2019 09:43:46 GMT

Thank you Simrankaur