Exclude ID's with a specific value in Load Statement

[karan_kn]

Exclude ID's with a specific value (A)in Load Statement

LOAD * INLINE [
ID, Rank, Sub
1, A, 23434
1, B, 4546
1, C, 5675
2, B, 34234
2, C, 546456
3, A, 78686
3, B, 3523523
3, C, 68685
3, D, 35354
4, B, 57568
5, B, 3242
5, C, 7878
5, D, 35325
6, A, 56756
6, B, 87979
7, B, 789703
7, C, 354367
7, D, 7979
7, E, 46546
];

[kaushiknsolanki · Accepted solution]

Try this, 

Data:
LOAD * INLINE [
ID, Rank, Sub
1, A, 23434
1, B, 4546
1, C, 5675
2, B, 34234
2, C, 546456
3, A, 78686
3, B, 3523523
3, C, 68685
3, D, 35354
4, B, 57568
5, B, 3242
5, C, 7878
5, D, 35325
6, A, 56756
6, B, 87979
7, B, 789703
7, C, 354367
7, D, 7979
7, E, 46546
];

Filter:
Load ID as ID_to_Filter
Resident Data where Rank ='A';

Output:
NoConcatenate
Load * Resident Data where not Exists(ID_to_Filter,ID);

Drop table Data,Filter;