7 Replies Latest reply: Sep 26, 2013 4:30 PM by Ahmed Syed RSS

    Know match and does not match

      Hi,

      If I have the following 2 list:

      CitiesList
      New York
      Los Angeles
      Chicago
      Houston
      Philadelphia

       

      Cities
      NY
      Los Angeles
      Nueva York
      Phoenix
      Dallas
      Houston

       

      How to get something like this?:

      AllCitiesInCitiesNewInCities
      New YorkNN
      Los AngelesYN
      ChicagoNN
      HoustonYN
      PhiladelphiaNN
      NYNY
      Nueva YorkNY
      PhoenixNY
      DallasNY

       

       

      I need to know the cities that matches in 2 lists, and the differences between them.

       

      Thanks!