Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

AND Condition in where clause Load statement

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: AND Condition in where clause Load statement

3 Replies
Highlighted
Creator II
Creator II

Re: AND Condition in where clause Load statement

Flag1Flag2 
YYLoad
YNLoad
NYRemove
NNLoad
Highlighted
MVP & Luminary
MVP & Luminary

Re: AND Condition in where clause Load statement

Highlighted
Digital Support
Digital Support

Re: AND Condition in where clause Load statement

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.