Fetch non matching records between two tables

[Aspiring_Developer]

Hi All,

I have two tables like below :-

Table A:

QSUSer,
Access 

From Qliksesne AD ...

Table B:

User, Access

From text...

My requirement is to fetch the records which are present in txt file (Table B) but not in AD (TableA).

User

QS User

I need to compare the values of these two columns and need to identify the usernames present in user file but are missing in QS user list. Further i need to store them into QVD as i will be re-using those non matching records again.

Can anyone please help me ?

[kaushiknsolanki · Accepted solution]

Try this.

QS_User:

Load QSUser, Access from QSUSER;

NonMatchedUser:

Load User, Access from User where not exists(QSUser,User);

[Aspiring_Developer]

Hello @kaushiknsolanki 

Tried  but getting error 'QsUSer' not found