Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
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
maxgro
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
sibideepak
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.

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

oknotsen
Master III
Master III

See (another) example here:

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

May you live in interesting times!
qlikviewwizard
Master II
Master II
Author

Thank you for nice explanation.