topic Re: Using condition in Data Movement & Streaming

Using condition

Jahnavi2408 — Wed, 19 Mar 2025 22:11:20 GMT

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.

Re: Using condition

Clement15 — Tue, 19 Mar 2024 09:08:34 GMT

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

Re: Using condition

Jahnavi2408 — Tue, 19 Mar 2024 09:23:25 GMT

Thank you so much for the solution.

Re: Using condition

Jahnavi2408 — Tue, 19 Mar 2024 09:42:02 GMT

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.

Re: Using condition

Clement15 — Tue, 19 Mar 2024 09:45:48 GMT

Like this ?

Load *

from Field

where countries ='ind'

and salary = 200000

Re: Using condition

Jahnavi2408 — Tue, 19 Mar 2024 09:54:13 GMT

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);

Re: Using condition

Clement15 — Tue, 19 Mar 2024 09:56:19 GMT

You cannot use the and in the match

Re: Using condition

Jahnavi2408 — Tue, 19 Mar 2024 09:59:05 GMT

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

row1- city

row2- latitude

Re: Using condition

Clement15 — Tue, 19 Mar 2024 10:01:51 GMT

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'

Re: Using condition

Jahnavi2408 — Tue, 19 Mar 2024 10:46:45 GMT

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

Re: Using condition

Clement15 — Tue, 19 Mar 2024 10:05:31 GMT

Could you give me an example of your data?