3 Replies Latest reply: Jul 9, 2012 6:18 AM by Jonathan Dienst RSS

    Mapping 3 unrelated field values

      Hi,

       

      I would like to map 3 unrelated field values to a new field.

       

      In more detail:

       

      I have the fields:

       

      1) WebSite

      2) Language

      3) CustomersCountry

       

      I want to create a new field based on the values of these fields. The following table has an example logic:

       

      WebSite
      Language
      CustomersCountryNewField
      site1.ru(any value)(any value)Russia
      site2.ru(any value)(any value)Bulgaria
      site3.ru(any value)(any value)Ukraine
      anothersite.ro(any value)(any value)Romania
      home24.comRussia(any value)Russia
      home24.comRomania(any value)Romania
      home24.comBulgaria(any value)Bulgaria
      travel.gr(any value)CyprusCyprus
      travel.gr(any value)GreeceGreece

      '

      e.t.c.

       

      What is the best way to do that?

       

      Thanks in advance

      Panayotis