Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
One of the recent questions I had to answer focused on analyzing text data. How have you solved this problem in the past? I was not sure how to create an optimized solution for both efficiency and completeness. My solution I came up with used a join condition that had the following query structure:
  , text_data.text
  , keywords.keyword
  join keywords on
    text_data.text like concat('%', keywords.keyword, '%')
This seemed like a brute force method, but it worked.
Version history
Last update:
‎10-26-2021 03:49 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: