Find Key Words and Phrases in Free Text Fields

    Sometimes data comes in a free text format, customer comments and feedback are a great example. Here we have a wealth of information a company could harvest and dashboard in QlikView although because it’s free text is becomes difficult to summarise.

     

    This code reads each comment field and searches it for a key word or phrase and counts the occurrences.


    Key Words / Phrases

    Key Words.png


    Free Text Comment Field

    Free Text Comments.png


    Output Table

    Output Table.png

     

     

    Due to the fact its reading each possible word or phrase and reloading the comments each time this process could take a while the more data you have although typically comment type fields are small volumes. I would also use an incremental QVD builder to ensure I’m only transforming new data once.


    Happy Qliking
    Richard

    Find more blog posts at QlikCentral.com