Load and replace if text in another field

[#1]

Hello

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

the table looks something like this

a	b	c	d
something	a1	23
something else	b2	43
something	c3	12
something else	d4	2

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

[sivarajs · Accepted solution]

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

[#3]

Hey thank you for responding.

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

[#4]

load

a, b,

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

from table.xls

[SunilChauhan]

see the attached file

hope this helps

[Gysbert_Wassenaar]

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