If contains, else in load

[rachelpurple]

I want to create a new column N that would look at the value of Column A, if Column A contains stream as 'abc', then the value of Column N should be 'Yes', if not contain 'abc', the value should be 'No'.

In excel, for Column N it is something like: =IF(ISNUMBER(SEARCH("abc",A1)),"Yes","No").

I want to do that in Qlik by adding a new Column and call it 'N'. How to do that? Thanks in advance

[Anonymous]

IF(A='abc', 'Yes', 'No')                    AS          N

[el_aprendiz111 · Accepted solution]

Hi Luda,

1 option:

tmp:
LOAD *, IF(WildMatch(MyField,'*ABC*'),'YES','NO') AS NewField;
LOAD * Inline
[
MyField
ABCDEF
123ABC
DES123
HNT6778
098FBGG
OOOABC
];

[MarcoWedel]

If(Index(A,'abc'),'Yes','No') as N

hope this helps

regards

Marco

[rachelpurple]

Thanks very much, it works!

[rachelpurple]

Thanks very much, it works!

[vishsaggi]

Hello Gan, can you close the thread marking correct/helpful responses accordingly.

Thanks
V.