How to create multiple table to one QVD

[shabarish0587]

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.

[simrankaur · Accepted solution]

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. 

[shabarish0587]

Thank you Simrankaur