Problem with excluding data in script

[#1]

Hi

I want to exclude all data that are connected to a testuser. SFTEST, on that I´m trying to exclude post that don´t have FROMDAT or TOMDAT. I don´t get it working...

From .... qvd

WHERE ((NOT ISNULL(FROMDAT) OR NOT ISNULL(TOMDAT) OR Substringcount(Upper(INSHAND),'SFTEST')=0));

Can I do this or do I have to solve it on some other way?

BTW, by Substringcount(Upper(INSHAND),'SFTEST')=0)) seems only to exclude the user SFTEST from Userlist(INSHAND) but not the connected data(?)

/thanks!

[SunilChauhan]

WHERE ((NOT ISNULL(FROMDAT)  and NOT ISNULL(TOMDAT) and Substringcount(Upper(INSHAND),'SFTEST')=0));

hope this helps

[vmrodrigues]

Hi,

Why don't you try just to use the EXISTS function? Something like:

LOAD

....

FROM ...

WHERE NOT EXISTS(SFTEST_KEY,'TEST_KEY_TO_EXCLUDE');

Cheers,