topic Re: If contains, else in load in QlikView

If contains, else in load

rachelpurple — Wed, 01 Nov 2017 17:35:20 GMT

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

Re: If contains, else in load

Anonymous — Wed, 01 Nov 2017 18:45:07 GMT

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

Re: If contains, else in load

el_aprendiz111 — Wed, 01 Nov 2017 22:08:01 GMT

Hi Luda,

1 option:

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

Re: If contains, else in load

MarcoWedel — Wed, 01 Nov 2017 22:10:21 GMT

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

hope this helps

regards

Marco

Re: If contains, else in load

rachelpurple — Thu, 02 Nov 2017 13:36:58 GMT

Thanks very much, it works!

Re: If contains, else in load

rachelpurple — Thu, 02 Nov 2017 13:37:06 GMT

Thanks very much, it works!

Re: If contains, else in load

vishsaggi — Thu, 02 Nov 2017 14:09:47 GMT

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

Thanks
V.