1 Reply Latest reply on Nov 20, 2016 3:28 PM by Bill Lyons

    Create dimension from a free text comments field

    Nathan Masters

      Hi All

       

      I would like to create a dimension from a free text comments field. Please refer to the screen capture below. Essentially what I am attempting to derive is the following:

       

      If comments field contains the word "compliant", then show "Compliant", all else should be classified as "Not Compliant"

       

      Can anyone please assist?

       

      Thanks for your help.

       

      Cheers

       

      Nathan