topic Re: Load and replace if text in another field in QlikView

Load and replace if text in another field

Mon, 28 Jan 2013 12:11:28 GMT

Hello

I'am trying to replace a value if text is present in another table is this possible ?

the table looks something like this

Here i want to chage the c table to 0 if the text "something else" is in table a

sivarajs — Mon, 28 Jan 2013 13:17:48 GMT

if(wildmatch(a,'*something else*'),0,a) as c

Mon, 28 Jan 2013 13:32:18 GMT

Hey thank you for responding.

I am getting "Field names must be unique within table" from this.

Mon, 28 Jan 2013 13:44:29 GMT

load

a, b,

if(wildmatch(a, 'something else'),0,c) as c

from table.xls

SunilChauhan — Mon, 28 Jan 2013 13:51:12 GMT

see the attached file

hope this helps

Gysbert_Wassenaar — Mon, 28 Jan 2013 13:52:44 GMT

Make sure you're not already loading field c, for example with load *. You'll have to list the field names individually.

load a,b,d, if(wildmatch(a,'*something else*'),0,a) as c

from ...somewhere...;