Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ak00428233
Contributor III
Contributor III

Condition clause while writing where not exist condition

Hi All,

I have gone through Exists and not exists condition.Could you please guide me regarding the condition.

Employees:

LOAD * inline [

Employee|ID|Salary

Bill|001|20000

John|002|30000

Steve|003|35000

] (delimiter is '|');

Citizens:

Load * inline [

Name|Address|ID

Bill|New York|001

Mary|London|004

Steve|Chicago|003

Lucy|Paris|005

John|Miami|002

] (delimiter is '|');

EmployeeAddresses:

Load Name as Employee, Address Resident Citizens where not Exists (Employee, Name);

In the above expression the condition was used between (Employee,Name).But could any suggest me to use this condition for ID also in the same table EmployeeAddresses.

Thanks in advance

Regards,

Anu

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this:

.

.

.

EmployeeAddresses:

Load Name as Employee,

          Address,

          ID

Resident Citizens

where not Exists (Employee, Name) and not exists(ID);

View solution in original post

4 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

.

.

.

EmployeeAddresses:

Load Name as Employee,

          Address,

          ID

Resident Citizens

where not Exists (Employee, Name) and not exists(ID);

ak00428233
Contributor III
Contributor III
Author

Thank you youssef. It is working fine now.

YoussefBelloum
Champion
Champion

You're welcome.

Good luck

ak00428233
Contributor III
Contributor III
Author

Thank you youssef.