2 Replies Latest reply: Mar 15, 2016 12:34 PM by Sunny Talwar RSS

    help with if statement.....

    Rickard Andersson

      [stupid question alert]

       

      I got this in my load statement.

       

        left(subfield(FileName(),'Open',2),8) As Test1,

        if(left(subfield(FileName(),'Open',2),8) = 'Changes','CHG','INC') As Test2

       

        and getting this result...

       

      Capture.PNG

       

      what do I do wrong....