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 ];
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.
.png "Former Employee"){kind=icon}
