1 Reply Latest reply on May 27, 2016 8:42 AM by Mahfooj Khan

    How to categorize a dimension based on its values

    Mohit Sharma

      Hi,

       

      I have following sample table of data:

      Header 1Header 2
      DogHouse
      CatPlayground
      RabbitPlayground
      CatHouse
      ParrotPlayground
      DogPlayground
      CatPlayground

       

      Now based on Header 2 values, I want to update those values of Header 1 as 'Lost' which only has 'Playground' as Header 2 value and no 'House' value with it. Simply I want below table as output:

       

      Header 1Header 2
      DogHouse
      CatPlayground
      RabbitLost
      CatHouse
      ParrotLost
      DogPlayground
      CatPlayground

       

       

      Usually for numeric expressions, I use LOD to solve the problem, but here the values are string and not numeric expressions. Also I cannot directly apply REPLACE function without any data manipulation. Any advice on this??!!

       

      Best regards,

       

      Mohit