Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where statement issues

I am trying to exclude junk emails during my script, the statement ends in the following

Where (

`recipient-address`='administrator1@company.com' OR

`recipient-address`='administrator2@company.com

)

and (left(`sender-address`,3) <> '/O=' OR left(`sender-address`,3) <> 'EX:')

Group by msgid,`recipient-address`;

My problem is that there are still email addresses being included that should have been excluded (starting in /O= or EX:) - my recipient addresses are correct but they do not exclude the sender addresses?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the sender-address part of the logical condition, change the OR in an AND. Neither one of them should appear.

View solution in original post

1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the sender-address part of the logical condition, change the OR in an AND. Neither one of them should appear.