Where not match, any of multiple entries

[alenb]

I have a load something like this:

DATA:

Load x, y, z From [a.qvd](qvd)

Where Not Match (x, 'a', 'b');

Load x, y, z From [a.qvd](qvd)

Where Not Match (x, 'a', 'b');

Is it possible to have a table with the entries ('a', 'b',...) that I would like to exclude, and then simply refer to the whole table.

Pseudo code:

EXCLUDE:

Load Inline * [

ITEMS

a

b

]

and then

Where Not Match (x, EXCLUDE);

[OmarBenSalem · Accepted solution]

You can use the where not exists funcitons, sthing as follow :

Exclude :

load * Inline [
ToExclude
A
B
];

table:
load * Inline [
Field1,Field2
A,1
B,2
C,3
D,4
E,5
F,6
]
where not Exists(ToExclude,Field1)