Applymap using like

[ecabanas]

     Hi,

I'would like to mark a field deppending on the value.

For example if the fiel source "contains" the word "black"  1 ifnot 0 as XX

Many thank's

Eduard         

[el_aprendiz111 · Accepted solution]

Hi Eduard

LOAD *,
if(WildMatch(String,'*black*'),1, 0) as XX
INLINE [ 
String 
test 001 
test 002 
test 010 
test 013 
test 234 
Text With black Spaces 012345 
TextWith black Spaces 0012346 
TextWithTwo Spaces 00012347 
TextWithOneSpace 000012348 
TextWithoutSpaces0000012349 black 
5 
06 
070 
Just a textwithout numbers 
];  

[sunny_talwar]

You can consider using MapSubString Function with subfield or Text between:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/MapSu...

May be provide a sample to help you better here

[ecabanas]

Thank's Fer fer you are goooood