Inline load and string search

Thu, 03 Oct 2013 13:34:11 GMT

I want to search a field for an occurrence of specific keywords and then set a flag if found.

Thinking that I want to use an inline load to pull in a list of keywords and then was going to use index to search the string. I can get it to work ok without the ApplyMap e.g. if((index(@36:n,'Error:') >0 ) , 'ERROR', 'OK') as ErrorFlag but at a loss on what the syntax is for using the ApplyMap.

Was trying to use something like :

KeywordsMap:

MAPPING LOAD * INLINE [

F1,F2

Error:, 9999

Failure:9999

];

if(index(@36:n, ApplyMap('KeywordsMap', @36:n)) <> 0 , 'ERROR', 'OK') as ErrorFlag

I've searched but can't see anything specific to this and being new to Qlikview not sure if this is best approach or if there's a better alternative.

Thanks

Re: Inline load and string search

christian77 — Thu, 03 Oct 2013 14:13:48 GMT

Hi.

Try to use SubStringCount(YourField).

If you are using a MAPPING, don't use IF clause.

applymap('KeywordMap',YourField) as ErrorFlag

Try to rename those fields called @..

luck

topic Re: Inline load and string search in QlikView

Inline load and string search

Re: Inline load and string search