Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 

Comparison of two seperate Datasets

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

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!

2 Replies

Update, maybe the problem gets clearer then:

I have two filterboxes (A and B) now with mostly the same content, and only a few differences. Now i would like to have a third box (or a table, diagram, whatever...) which lists all the elements, that is present in filterbox B but not in Filterbox A. Any Ideas?

Former Employee
Former Employee

@schmimla21 From what you describe, it would seem to me that is going to require Set Analysis, here is a Design Blog post that may be of some help and the Help Doc link below that:

The only other way to go at it would be to load all the data into your data model and be sure the tables are connected appropriately such that you can get the resolution you want that way.  Hopefully this may get you on the right track.

One more Help link for you:


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.