Condition clause while writing where not exist condition

[ak00428233]

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

[YoussefBelloum · Accepted solution]

Hi,

try this:

.

.

.

EmployeeAddresses:

Load Name as Employee,

          Address,

          ID

Resident Citizens

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

[ak00428233]

Thank you youssef. It is working fine now.

[YoussefBelloum]

You're welcome.

Good luck

[ak00428233]

Thank you youssef.