7 Replies Latest reply on Oct 11, 2018 4:58 AM by Jeevan Sequeira

    Keyword Search

    Jeevan Sequeira

      Hi,

      I have a question concerning filters/groups/sets/calculated fields.

      Here is my requirement:

      -------

      I have two comment fields in my source data - 'Description' and 'Justification'

      I need to check for certain strings in these two columns and flag them accordingly.

      For example, 

      Search-KeywordFlag-As
      FRAUDF1
      AUDITF1
      AVOIDF2
      BREAKF2
      BETRAYF2
      CONCEALF3
      CONSPIRF4

      I then need to have a multi-select dropdown filter on the Flag value - All F1 F2 F3 F4.

      If the 'Description' field has a text called 'Avoid Fraud', it should display when I select both F1 and F2.

      ------

      I tried doing a 'if-contains' logic and split it into 4 calcualted fields F1 F2 F3 F4. Then concatenated them in a new calculated column.

      DescriptionJustificationF1F2F3F4
      There is no FraudSome text hereF1
      Some text hereTo be avoidedF2
      Avoid conspiracyDon't concealF2F3F4
      Fraud and conspiracySome text hereF1F4

       

      I then combined the fields in a new field 'Test Case' = F1 + F2 + F3 + F4

      Test Case
      F1
      F2
      F2F3F4
      F1F4

      Now if I use 'Test Case' column as my filter, the user has to select F1 and F1F4 to see all F1 data.

      This is not feasible as there more than 10 Flag criteria and combinations will be endless.

       

      I just need to have four values in the drop-down F1 to F4. And if I select F1, it should display all rows with F1 as well as combination with other flags as well.

      Kindly suggest an alternate solution.