Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this:
If(not Match(TXN_TYPE,1,2,4),REF_NO) AS OTHERS,
Is this what you are after?
if(MATCH(TXN_TYPE,1,2,4) = 0, REF_NO) AS OTHERS,
Try with quotes
if(MATCH(TXN_TYPE,'1','2','4')=0,REF_NO)) AS OTHERS,
may be this?
if(TXN_TYPE<>1 or TXN_TYPE<>2 or TXN_TYPE<>4 ,REF_NO) AS Others