Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys,
I have a field with the name "Purchase Order ID", I need to exclude the values which contain "A".
Not WildMatch doesnt work properly
<> "A"
Where not [Purchase Order ID] ='A'
Test for wildmatch(fieldname, '*A*') = 0 or for wildmatch(fieldname, '*A*') >0 to test for "not like" or "like" respectively.
You can also use index()
where index(fieldname, 'A') = 0 will only select data that does not contain A in fieldname.
tab:
BUCKET:
LOAD * INLINE [
porid,amt
a,10
b,20
c,30
];
=If(porid <>'a',sum(amt)) --on ur expresion