topic Re: Applymap using like in QlikView

Applymap using like

ecabanas — Fri, 02 Dec 2016 15:49:30 GMT

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

Re: Applymap using like

el_aprendiz111 — Fri, 02 Dec 2016 16:09:58 GMT

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
];

Re: Applymap using like

sunny_talwar — Fri, 02 Dec 2016 16:10:05 GMT

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/MapSubstring.htm

May be provide a sample to help you better here

Re: Applymap using like

ecabanas — Fri, 02 Dec 2016 16:19:29 GMT

Thank's Fer fer you are goooood