Select from field exists function

Anonymous — Tue, 25 Jan 2011 10:14:31 GMT

Thanks in advance for your replies.

I have a data table which loads a few fields including 2 fields - owner and user.

The file belongs to the owner but any user can work on it, owners can also be users.

I need to flag users who do not exist in owners field

What I need but cannot figure out is something like

SELECT from user WHERE they do not exist in owner on any row at all, ever (so exclude owners from users list)

I tried with exists function but no joy

Hope this makes sense

Thanks again

maneshkhottcpl — Tue, 25 Jan 2011 11:17:45 GMT

Hi,

Use the following.

// Gives u the owners

Load distinct owners as Owners_T from table;

Load * from Table where not exists (Owners_T, users);

drop table A;

will work.

or send me ur application with sample data.

topic Select from field exists function in QlikView