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
if(wildmatch(a,'*something else*'),0,a) as c
Hey thank you for responding.
I am getting "Field names must be unique within table" from this.
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
if(wildmatch(a, 'something else'),0,c) as c
see the attached file
hope this helps
Retrieving data ...