Webi variable: Count word frequency in a string
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.
Nikhil Joy replied
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.