Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have trolled and trolled and still don't get what seems to a very simple thing. I am loading from a qvd. I just want to exclude about 40 specific records from the load, but I cannot seem to make it work. SQL "Not in" does not work, not match does not work, not = does not work... Any ideas?
OK, in that case the Match() function is the simplest solution; viz
LOAD
case,
... // your other fields
FROM yoursource.ext(...)
WHERE not Match(case,17, 21, 39, 155);
Angus.
It depends on the degree of complexity of your criteria. What is your basis for deciding which records to keep and which to discard?
I have let’s say ten thousand records loading from the qvd where field “case” is 1, 2, 3, …10,000.
I want to exclude 40 very specific records where “case” is 17, 21, 39, 155…
OK, in that case the Match() function is the simplest solution; viz
LOAD
case,
... // your other fields
FROM yoursource.ext(...)
WHERE not Match(case,17, 21, 39, 155);
Angus.
BINGO! Thank you Angus!
Another satisfied customer