Getting insights from string field

[MaharshiC]

Hi,

I have a custom string field in my custom table. Now the client wants to get some meaningful insights from this string field. How can I give some meaningful insight from this field? He also wants to show them in a sort of report also later. This insight may include frequency, sentiment, importance of words. Can we use predictive intelligence or by some other way? Any reference URL will also help .

[Mark Manders]

The old dashboards will still work, so you can add them there and migrate. Or just keep using them. As of Australia they will be read only, but that's over half a year away.

[GlideFather]

Hi @MaharshiC,

it is always more difficult to think of the design or process of how it is supposed to work rather than to do it...
You said that your client wants "some meaningful insights"... well, it really depends on details.

You have a string field - what insight would you like to get from it? String will be in 99 % always different unless you have some automated population of the field, otherwise every person will write something else in a string field.

And predictive intelligence needs data to "learn" from it.
Your question is very vaguely described and it is not clear what would you like to achieve.

Can you share some details? Describe the use case and it will be easier to discuss some possibilities but with this it is not much possible. Thank you

[MaharshiC]

HI @GlideFather  ,

Thanks for your reply.

If we can show the client may be the top words used in the string , their frequency in a graphical way  then that will be good for them. But is that feasible? I know we can use  a custom table and and get the count of each word and then get a report out of it but as that will create huge number of records in the custom table so that is not a feasible option. 

[Ankur Bawiskar]

@MaharshiC 

you can use Text analytics

check below links for help

Text analytics and text widgets 

Solved: How to create a Word Cloud Dashboard from ts_query... - ServiceNow Community

If my response helped please mark it correct and close the thread so that it benefits future readers.