Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Webi variable: Count word frequency in a string

Hallo guys

This is a tricky one. The requirement is that there is a free text field in the table, and we need to count the word occurences in those strings all together.

i.e. row 1 - My name is Antonette

      row 2 - Did I tell you my name?


    my : 2

    name : 2

    is : 1


The result should be a tag cloud to show which words stand out.

How do we achieve this in Webi?

We are on 4.1, the data is in a SQL db.




Hello Antonette,

Your requirement is a typical case of unstructured data analysis and unfortunately webI is no the right tool for it. Unstructured data analysis is something you have to do either in database level or ETL level as shown in below examples. Once you have the key words with count available, you can use WebI or Lumira to represent it.  SAP HANA supports unstructured data analysis, and most of the ETL tools also support this logic.

check below links for more understanding.

Analyze unstructured data in SAP Lumira with Text Analysis

Using Lumira with Text Analysis to see What is Coming to Reporting 2013 Conference


Nikhil Joy

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question