topic Re: Where Not Exists in QlikView

Where Not Exists

qlikviewwizard — Thu, 19 Mar 2015 08:27:11 GMT

Hi All,

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

Thanks in advance.

Re: Where Not Exists

sibideepak — Thu, 19 Mar 2015 14:28:19 GMT

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.

Re: Where Not Exists

maxgro — Thu, 19 Mar 2015 14:35:58 GMT

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);

Re: Where Not Exists

oknotsen — Thu, 19 Mar 2015 14:39:54 GMT

See (another) example here:

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

Re: Where Not Exists

qlikviewwizard — Thu, 19 Mar 2015 15:09:20 GMT

Thank you for nice explanation.