I have to validate 2 columns while loading my data.

I tried using this logic.

Need to load RECORD_TYPE in (1, 3).

Send me the syntax for the same.

I tried something like this...
LOAD DATA
APPEND
INTO TABLE IPDR_3G_REL2_TMP
WHEN VENDOR != 'TRA' AND VENDOR != 'HEA'
AND (RECORD_TYPE = '1' OR RECORD_TYPE = '3')
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS

I am getting syntax error.

Please revert.

Cheers...