Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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)
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)