how find the count of any 2 keywords in a particular string ?

[#1]

Hi

I have a list of words with column name as keyword. I need to find the no  any two  keywords present in the particular description column what i have with me.

For ex:

List of keywords:

memory,

cpu,

access,

adobe,

outlook

etc

Description:

the cpu memory is full.  (here keywords are 2 )

unable to access outlook. (here keywords are 3 )

[swuehl]

Mehare Nigar wrote:

Hi Swuehl,

Here in the logic we are considering the substring count due to this i guess it is considering the count of words within same single word

for ex:

if the description is like " cpu is down"

then it is checking for a word call ''is'' from the description in the keyword column. But keyword ''is'' actually does not exist, in fact it is picking the word is from the description to the keyword called something like ''issue''

Can you suggest how to avoid this in such case?

Can't reproduce this.

MAP:

MAPPING

LOAD List, '%MATCH%' as F2 INLINE [

List

memory

cpu

access

adobe

outlook

issue

];

LOAD *, SubStringCount(MapSubString('MAP',Text),'%MATCH%') as Count, MapSubString('MAP',Text) as Map INLINE [

Text

the cpu memory is full.

unable to access outlook.

];

Here, you see 'is' in first Text value mapped to issue?

[#3]

Yes, I want the exact keyword to be mapped not the substring of the keyword.

[swuehl]

And where exactely do you see a substring of the keyword mapped? Can you post a sample QVW?