Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(wildmatch(a,'*something else*'),0,a) as c
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.
load
a, b,
if(wildmatch(a, 'something else'),0,c) as c
from table.xls
see the attached file
hope this helps
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...;