4 Replies Latest reply on Jan 27, 2015 10:30 PM by Takehiro Masaki

    update country field by multiple condition

      I want update the lead's country field by multiple condition using a list.
      for example,below is a list that contain old value and new value:
      old valuenew value
      AMARMENIA
      AOANGOLA
      ARARGENTINA
      ATAUSTRIA
      ....
      ....

      if the old country value is 'AM',than change the country to 'ARMENIA',if the old country value is 'AO',than change the country to 'ANGOLA',......
      I thought it can be implement by createing a campaing and using Change Data Value in it,
      but I should create many more choices.

      Anybody knows how to do it with a easy way?