topic Re: Is it possible to search multiple key words at same time? in QlikView

Is it possible to search multiple key words at same time?

Thu, 19 Feb 2015 04:44:19 GMT

Is it possible to search multiple key words at same time?

In my QVD text field, I have 3 search terms. 1. AUTO 2. COGS 3.DAL. These search terms are in middle of the big string text.

My requirement is search a key word in Text and find 500 characters before and after key word.

Via below query, I was able to search one key word successfully.

The question is ….Is it possible to add other key word in same query without repeating the same process with 2^nd key word?

LOAD

*,
mid(Review,index( upper(Review), 'AUTO' ),500) as Mid_Example_Plus,
mid(Review,index( upper(Review), 'AUTO' ) -500,500) as Mid_Example_Minus,
index( upper(Review), 'AUTO' ) as index_example

RESIDENT Reviews
WHERE index( upper(Review), 'AUTO' ) > 0;

Re: Is it possible to search multiple key words at same time?

PrashantSangle — Thu, 19 Feb 2015 04:55:15 GMT

Hi,

Use match() or wildmatch()

try like

wildmatch(fieldname,'*AUTO*','*COGS*','*DAL*')

Regards

Re: Is it possible to search multiple key words at same time?

rwunderlich — Thu, 19 Feb 2015 06:34:38 GMT

I've adapted a QlikViewCookbook.com example that indexes keywords to extract the range of 5 characters before and after the Keyword as an Excerpt field. Example attached, see if you can adapt it to your needs.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Is it possible to search multiple key words at same time?

Thu, 19 Feb 2015 23:49:29 GMT

This is wonderful and did work. Is there way I filter just extract only 'key word' match records? Now I am seeing all records. I just want to see only matched records and discard 'non-match records'. Is it possible?

Thanks,

Re: Is it possible to search multiple key words at same time?

rwunderlich — Sat, 21 Feb 2015 19:27:22 GMT

In the example I supplied add, the end of the script.

// Delete Reviews that don't have any keywords

INNER JOIN (Reviews)

LOAD ReviewId

RESIDENT Keywords2

;

Adapt to your specific script.

-Rob

http://masterssummit.com

http://robwunderlich.com