Using condition

[Jahnavi2408]

can we able to use multiple condition in a where clause?

for ex: we are having several countries. ( ind, aus, eng,pak)

i need to filter and show only ind and aus.

so, how we can write script using where condition. 

can anyone please share your ideas for my learning.

[Clement15 · Accepted solution]

Hello, you can use something like this

Load *

from Field

where match(countries,'ind','aus')

If the Where clause concerns different fields, you can add an “and” then the following condition

[Jahnavi2408]

Thank you so much for the solution.

[Jahnavi2408]

where match(countries,'ind','aus')

in this same condition, if i wanted to check for IND and different fiels like salary 200000. 

how can we use the condition using AND in the where clause.

[Clement15]

Like this ?

Load *

from Field

where countries ='ind'

and  salary = 200000

[Jahnavi2408]

if i try to add the AND in the where condition, i cant able to see the data for both. for country as well as for salary. 

this is my condition, for this i cant able to see the data.

where match(City,'Chicago' and Latitude = 40.730599);

[Clement15]

You cannot use the and in the match

[Jahnavi2408]

So, what is the way to check 2 rows in the single where condition.

row1- city

row2- latitude 

[Clement15]

The match is useful if you have several categories selected for your field, otherwise the = is enough.
Does this formula work?

where City='Chicago'

and Latitude = '40.730599'

[Jahnavi2408]

Running successfully, but cant able to see the data in data manager.