4 Replies Latest reply on Nov 24, 2015 10:42 AM by srinivas.anupoju.0

    URGENT - How to alias the dissimilar texts to single text value with aliasing ??

    srinivas.anupoju.0

      Hi,

       

      Very Urgent Requirement.

       

      Requirement - The field description has multiple entries for a similar with different texts as attached in the image. Description is the field name having values "Initial Impact changed from 4 to 5.." and "Initial Impact changed from 4 to 5". I want to alias both of them into "Initial Impact changed from 4 to 5" only. Similarly I have in the same column "Impact was changed from 4 to 3" and "Initial Impact was changed from 4 to 3", I wanted to alias it into "Initial Impact changed from 4 to 3".

       

      My Calculation below is showing valid

      -------------------------------------------------------------------------------

      If [Description] = "Impact was changed from 4 to 5"

      OR

      [Description] = "Initial Impact was changed from 4 to 5"

      THEN

      "Initial Impact changed from 4 to 5"

      END

      -------------------------------------------------------------------------------

      The result is NULL out of it

      -------------------------------------------------------------------------------

       

      Keeping Multiple aliasing for the same column is not possible in mind am looking for some really urgent help on this issue.

       

      Please suggest some ideas and if we have a way to solve this.

       

      TIA

       

      Warm Regards,

      Srinivas Anupoju