topic Re: Populate a field with keywords in QlikView

Populate a field with keywords

gfisch13 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Populate a field with keywords

sunny_talwar — Wed, 10 May 2017 15:15:21 GMT

Something like this maybe

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

Re: Populate a field with keywords

gfisch13 — Wed, 10 May 2017 15:41:36 GMT

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?

Re: Populate a field with keywords

beck_bakytbek — Wed, 10 May 2017 16:19:11 GMT

Hi George,

look at this:

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

i hope that helps

Beck

Re: Populate a field with keywords

rwunderlich — Wed, 10 May 2017 16:46:57 GMT

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

Re: Populate a field with keywords

gfisch13 — Wed, 10 May 2017 17:27:01 GMT

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