Filter in QVD

Thu, 16 Apr 2009 13:49:32 GMT

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

Filter in QVD

disqr_rm — Sun, 19 Apr 2009 10:12:42 GMT

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.

topic Filter in QVD in QlikView

Filter in QVD

Filter in QVD