How to Exclude one department

[#1]

Can someone please help me with excluding one department.

For example AdmissionDept I want to exclude 6 NorthEast

How will I write a script?

Thanks!

[santharubban]

if(AdmissionDept <>'NorthEast' ,AdmissionDept)

[Clever_Anjos]

LOAD

*

from yourqvd(qvd)

where AdmissionDept <>'NorthEast';

[maxgro]

another one

load

     *

from

     ......

where not match(AdmissionDept, 'NorthEast');

[#5]

Thank you very much! That worked

[Clever_Anjos]

That´s great!

Please mark this question as answered.