I'm trying to select only the points which are from 100-300 using Match in where condition.
(Branch='ABC' and Match(Points, ' ')
Can anyone help pls.
Not sure I understand Mark, would you be able to elaborate?
I wanna select the values from the field "Point".
It should be of the range 100-300 for Branch 'ABC'
So, i'm trying to use the below code. But not able to specify range ....
You mean something like this?
Branch='ABC' and Points >= 100 and Points < 300
I was trying to know is there any way to use Interval match or any other function other than using Greater than and less than symbols.
You could use match(Points, 100,101,102, ...) or instead of match a mapping and applymap() or you could use a join-table as filter but what speaks against >= and <=?
(Branch='ABC' and Points >= 100 and Points <= 300)
To use Match you would have to list all the possible symbols in the range 100 - 300, so I think the previous suggestions will work better, although you could use
Where WildMatch(Points, '1??', '2??', '3??') as a condition
This will allow things like 1XY as well as numbers...
Yea an interessting approach but shouldn't it be: WildMatch(Points, '1??', '2??', '300').
Retrieving data ...