IF & MATCH

[upaliwije]

Hi,

I have following lines in my data load script

  if(TXN_TYPE=1,REF_NO) AS DEBIT_NOTE_NO,

     if(TXN_TYPE=2,REF_NO) AS SETT_REC_NO,

     if(TXN_TYPE=4,REF_NO) AS REFUND_SLIP_NO,

     if(NOT MATCH(TXN_TYPE,1,2,4,REF_NO)) AS OTHERS,

But the last line does not work . What I want is if TXN_TYPE<>1,2,4 the REF_NO should be others

Pls help me to correct abobe error

[sunny_talwar · Accepted solution]

May be try this:

If(not Match(TXN_TYPE,1,2,4),REF_NO) AS OTHERS,

[jonathandienst]

Is this what you are after?

if(MATCH(TXN_TYPE,1,2,4) = 0, REF_NO) AS OTHERS,

[vinieme12]

Try with quotes

if(MATCH(TXN_TYPE,'1','2','4')=0,REF_NO)) AS OTHERS,

[Anonymous]

may be this?

if(TXN_TYPE<>1 or TXN_TYPE<>2 or TXN_TYPE<>4 ,REF_NO) AS Others