Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

Where Not Exists

Hi All,

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

Thanks in advance.

1 Solution

Accepted Solutions
MVP
MVP

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

View solution in original post

4 Replies
Creator II
Creator II

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.

MVP
MVP

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

View solution in original post

Master III
Master III

See (another) example here:

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

May you live in interesting times!
Master II
Master II

Thank you for nice explanation.