Filter in QVD

[#1]

Hi All,

I have two qvd's.

QVD1 Fields: Emp name, Designation, Salary, Comm.

QVD2 Fields: Emp name, Designation.

Now I need to load the 1st QVD but filter out the values in the 2nd QVD. as below.

Load Emp name, Designation, Salary, Comm. from QVD1

where Emp Name not in (load Emp Name from QVD2)

Original Script:

QVD1:
LOAD * INLINE [
Emp_Name, Designation, Salary, comm
Brad, DD, 10000, 0.01
Neo, BA, 20000, 0.02
Lee, BB, 30000, 0.10
Ven, SA, 10000, 0.09
];
Store * from QVD1 into QVD1.qvd (qvd);

QVD2:
LOAD * INLINE [
Emp_Name, Designation
Lee, BA
];
Store * from QVD2 into QVD2.qvd (qvd);

Drop table QVD1;
Drop table QVD2;

Table1:
Load * from QVD1.qvd (qvd);
//where exists('Em_Name)

I need to filter out the above table with the values from qvd 2.

Lee and BA (Designation) has to be filtered out in the above table

[disqr_rm · Accepted solution]

You can always first load QVD2 in a temp table, then load QVD1 with NOT EXISTS() finction on Emp_name and Designation fields, then drop the first temp table. See enclosed. Hope this is what you are looking for.