6 Replies Latest reply: Dec 30, 2013 3:46 PM by Nicole Smith RSS

    Replace not working

      If field SalAccount is 'N/A', i would like to have it replaced by the value of field Corporate Account, else leaved unchanged. I have written this script

       

      LOAD IF([SalAccount]='N/A', Replace([SalAccount], 'N/A', [Corporate Account]), [SalAccount]) as [Sales Account]

      Resident Clean1;

       

      this is not working.

       

      do you have an idea ?