Two data sets with different amounts of records

[bazzaonline]

Hello,  I have pulled two sets of data into Qlikview and joined them by a unique reference number.  The second set of data is larger meaning I have data missing from the first set of data.

Is it possible to limit the data being display to the number of records contained in the first set of data??  Eg make it appear the extra data from the seconds set is not there at all?

Thanks You (Day two on Qlikview)

[MK_QSL]

Load

     Field1,

     CommonField,

     Field2....

From Table1;

Load

     Field3,

     CommonField,

     Field4....

From Table2

Where Exists(CommonField);

[rubenmarin · Accepted solution]

If there is a unique reference number by row you can use left join

Table1:

LOAD ... From table1;

Left Join LOAD ... From Table2;

[anbu1984]

TAB1:

load * inline [

country, sales

Brazil, 234

US, 432

Germany, 121

India, 444];

Join(TAB1)

load * inline [

country, Profit

US, 412

Germany, 488

India, 224

China,101];

NoConcatenate

Final:

Load * Resident TAB1 where Not(IsNull(sales));

Drop Table TAB1;

[bazzaonline]

Brilliant, worked perfectly!

[MK_QSL]

Kindly close the thread by selection appropriate answer...