Populate a field with keywords

[gfisch13]

Hi Everyone -

I have a field that includes a written narrative.  Within that field I'd like to be able to search for certain keywords and then populate those keywords in a new field (see attachment).  How/where would something like this be done............any help is appreciated.

Thanks!

[sunny_talwar]

Something like this maybe

If(WildMatch(Narrative, '*fraud*'), 'Fraud')

[gfisch13]

Let me expand on this a bit.  The data source I'm using will have thousands of records, and I will have a list of keywords I'm looking for...........I can see how the statement you posted would work, but I probably should have given a better description on how I'm using the data...............guessing this will need to be completed in the script?

[beck_bakytbek]

Hi George,

look at this:

https://www.youtube.com/watch?v=rIsbfthlTE4

i hope that helps

Beck

[rwunderlich · Accepted solution]

Download this example:

Qlikview Cookbook: Indexing Keywords in Text http://qlikviewcookbook.com/recipes/download-info/indexing-keywords-in-text/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[gfisch13]

Thank you all for your input, what a learning experience.