Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See attached qvw.
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;