3 Replies Latest reply on Nov 12, 2018 6:58 AM by Aym cham

    How to compare two string

    Aym cham

      Hi All,

       

      I would like to compare several strings present in the same dimension and keep the string with the best value, for example:

       

      i have the dimension "serie" and the measure "visitors"

       

       

      Serie                                                    Visitors
      Breaking bad s02 ep10 

      1230

      Prison break s01 ep011000
      Prison break s02 ep10920
      how i met your mother s01 ep10810
      Breaking bad s03ep12   720
      Prison break s01 ep12   530
      How i met your mother s02 ep12 300

       

       

      In this example, i would like to conserve just:

       

      SerieVisitors
      Breaking bad s02 ep10  1230
      Prison break s01 ep01   1000
      How i met your mother s01 ep10810

       

      Thanks in advance for your help.

       

      Aym.