4 Replies Latest reply: Sep 29, 2016 7:05 AM by balraj ahlawat RSS

    IF & MATCH

    UPALI WIJERATNE

      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