7 Replies Latest reply on May 16, 2018 9:13 PM by Sanket Deshpande

    Count occurrence of set of words in String dimension

    Sanket Deshpande

      Hi all,

       

      I have a scenario wherein i have a column called 'Problem Description' . I have a list of predefined words say 'Error', 'Mistake ' etc. in a dimension I want the count of these words across the 'Problem description' column.

      I cannot write static calculated field

      (contains([Problem description], 'error'))    for each word since the list of search words is large and  may change over time.

       

      Anything like - count of 'Search words' in 'Problem description'

       

      Kindly help,

      Sanket