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 :
MAPPING LOAD * INLINE [
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.