Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the meaning of Where Not Exists(Deptno,DepartmentNo);
Thanks in advance.
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);
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.
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);
See (another) example here:
http://community.qlik.com/message/726396#726396
Thank you for nice explanation.