Filters Issue

[renjithpl]

Hi All,

I need a clarification,

I have used where condition to filter few things, my code looks like below

... where not exists(Exclude, FieldName) and Field2 <> 0;

when i use this, my exists function not working as i want.

Can we use AND mode after we use not exists function.?

Regards

Ren

[dmohanty]

Hi,

Plz post the script to look at. Will help to analyze.

[Anonymous]

Yes, you can. Can you post the rest of the code, so we can see how your Exclude field is set up and what values are coming in on the load statement.

Jonathan

[renjithpl]

Actually, you are right, we can use AND after exists, I realised the problem. As i wanted to exclude few countries from Country field, as country is the primary key, and loading from different sources. I have filtered only in one source. Thanks anyways for the quick response. Cheers !