topic Re: Load if contain... as in QlikView

Load if contain... as

shahafei2 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Im trying to rename a value IF it contains 'ABC'

for the example i have the following values

1-ABC-2

2-ABC-3

ABC-4

5-ABC

bbbb

cccc7

456456etda

And i would like that the marked values will be changed to '1' so instead i will receive

bbbb

cccc7

456456etda

Im trying to use

Load

If(Desc='*ABC*',1,Desc) AS Desc

FORM ....

but for some reason i cant find '1' under the list box of Desc field

Anil_Babu_Samineni — Sun, 23 Dec 2018 12:59:35 GMT

Try this
If(wildmatch(Desc, '*ABC*'),1,Desc) AS Desc
Or
If(index(Desc, 'ABC'),1,Desc) AS Desc
Or
If(substring(Desc, 'ABC'),1,Desc) AS Desc

shahafei2 — Sun, 23 Dec 2018 13:38:01 GMT

Thank you,

The index function worked great for me