QlikView Data Analysis

[#1]

Hello Everyone,

My query is related to joining two datasets in QlikView and split out the difference

I have two datasets (example, see below). I would like to join this two datasets to check if the employee in dataset #1 is setup in second list or not. If not then my result should just fetch Joe Miller as result because that is the only emplyee which is not present.

How do you do this in QlikView? Please note, I tried to join these two tables in QlikView but the data displayed a result is a combined view which means all the entries in Dataset are displayed which is not what I want. My requirement is to view the difference from Dataset #1 point of view.

DataSet #1

Name	Department
Mark Stapleton	Energy
Joe Miller	Finance

DataSet #2

Name	Department
Mark Stapleton	Energy
Tim Cook	Marketing
Nigel Short	Marketing
Mark Fowler	Finance
Paul Leigh	Finance
Andrew Waller	Finance

Thanks for the help.

[Gysbert_Wassenaar]

See attached qvw.

[maxgro]

in script you can

Table2:

load *, Name & '-' & Department as NamDep;

LOAD * INLINE [

    Name, Department

    Mark Stapleton, Energy

    Tim Cook, Marketing

    Nigel Short, Marketing

    Mark Fowler, Finance

    Paul Leigh, Finance

    Andrew Waller, Finance

];

Table1:

load *

where not exists(NamDep,  Name & '-' & Department);

LOAD * INLINE [

    Name, Department

    Mark Stapleton, Energy

    Joe Miller, Finance

];

DROP table Table2;