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 ?