topic Re: AND Condition in where clause Load statement in QlikView

AND Condition in where clause Load statement

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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
];

Re: AND Condition in where clause Load statement

karan_kn — Wed, 18 Dec 2019 14:20:24 GMT

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

Re: AND Condition in where clause Load statement

rwunderlich — Tue, 24 Dec 2019 16:58:38 GMT

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

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

Re: AND Condition in where clause Load statement

Brett_Bleess — Mon, 23 Dec 2019 20:23:40 GMT

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