Hi, I don´t know how to name my topic prperly, but i hope that I can give a clear description of my problem. I´m no expert, so I have no idea where to start with...
So, on the one hand I have a table where I have loaded all Groups of our Active Directory and a corresponding table with all Members of the AD. Let´s say the table with the groups contains a group named "TS_USERS".
(By the way, I used this Cookbook to load the elements from the AD: )
http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/
When I select a certain group in the group-table, all members of this group are displayed in the member-table
On the other hand, I have a table where all users of a specific Oracle-Database are loaded. This table is not linked to the AD-Data. The users in this table all have a status, let`s say "active" or" inactive". Let´s assume the name of the table is "SYS_USERS".
What I want to do now is a query, which provides the following information: List all the users, who are members of SYS_USERS and have the Status "active" but are not members of the AD-group "TS_USERS". (To clarify: A user, who is not member of the group TS_USERS must not have status "active" in the "SYS_USERS"-Table)
I hope this is understandable. Since there is no link between the two Datasets, i can´t use a SQL-Query. So i wonder, if there are any functions in QS, that i can use.
Thanks in advance!
.png "Former Employee"){kind=icon}
