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.
Based on this description, I believe this should be a simple calculated field such as:
IF CONTAINS([Comment],"COMPLAINT") THEN "Complaint"
ELSE "Not complaint"
If that doesn't help, please attach a packaged workbook illustrating the problem in more detail. See Packaged workbooks: when, why, how .