Where Not Exists

[qlikviewwizard]

Hi All,

What is the meaning of Where Not Exists(Deptno,DepartmentNo);

Thanks in advance.

[sibideepak]

Hi qlikviewwizard ,

Say for example

Table1:

Load Deptno,DepartmentNo,DeptName From sample.xlsx();

Table2:

Load Deptno,DepartmentNo,DeptName From sample1.xlsx() Where Not Exists(Deptno,DepartmentNo);

when you add this your table it will concatenate the Table2 with your Table1 only unique row values ie) it will omit the duplicate values and load with it.

[maxgro · Accepted solution]

Dept:

load * inline [

Deptno, Desc, Country

1, desc1

2, desc2

3, desc3

];

concatenate (Dept)

load DepartmentNo as Deptno, Desc inline [

DepartmentNo, Desc

1, desc1

2, desc2

3, desc3

4, desc4

]

where Not Exists(Deptno,DepartmentNo);

[oknotsen]

See (another) example here:

http://community.qlik.com/message/726396#726396

[qlikviewwizard]

Thank you for nice explanation.