Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude certain values from a field in my table. Right now, I'm already using a where clause, " where Location equal like 'M*'
But I also need another where clause that only brings in the bolded products but since 93UK is in california and not a 'MO' location. It also should not be brought in. What function could i use to do include two where clauses?
Product, Location
11LB, MO-11
12JK, MO-12
93UK, California
BA193, Florida
AB197, Louisiana
LA102, Kentucky
Hi,
What is the condition you're using to identify the products in bold ?
You will need to use "and" so it considers both of these conditions for the same record in the where clause.
Theoretically, if you have an additional flag that indicates a bold product, your code could look like this:
Load Product, Location
from ...
where Location like 'M*' AND Product_Bold = 1;
If this doesn't answer the request, it would be helpful if you can clarify more.
Hi,
If you want to load only Those product whose location start with M
then write
Load *
from tablename
where wildmatch(Location,'M*')
It will load only those location which started M or m
If you want to apply any other condition then use And / Or Keyword as per requirement.
Regards
Hi,
Try like this
Load Product, Location
from ...
where Location like 'M*' AND Match(Product, '11LB', '12JK', '93UK');
Regards,
Jagan.
'