Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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);

View solution in original post

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

Thank you for nice explanation.