AND Condition in where clause Load statement

[karan_kn]

How to Remove the ID's with the only a combination of Flag1 = N and Flag =Y  where clause with the Load statement.

LOAD * INLINE [
ID, Flag1, Flag2
47597208, Y, Y
65686568, Y, N
76159217, N, Y
70042663, N, N
96509077, Y, N
97524382, Y, Y
686467195, Y, N
75351736, N, Y
68374107, N, N
57607445, Y, N
167453272, Y, Y
154963495, Y, N
154964393, N, Y
526263, N, N
39663468, Y, N
30830877, Y, Y
154969094, Y, N
23864847, N, Y
12905419, N, N
180543529, Y, N
154961890, Y, Y
127410060, Y, N
11112887, N, Y
152800, N, N
];

[karan_kn]

Flag1	Flag2
Y	Y	Load
Y	N	Load
N	Y	Remove
N	N	Load

[rwunderlich · Accepted solution]

Where not (Flag1 = 'N' and Flag2 = 'Y'  )

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Brett_Bleess]

Just want to point out to future visitors, the Flag should be Flag2 field...  I am going to mark Rob's post as the solution on this one, just wanted to add the clarification so nobody gets confused later.

Cheers,
Brett