How to identify exceptional data

[AS]

Hi all,

I know this could be a simple question for you guys but I'm having trouble building logic on this. could you please help me.

There are 2 tables A and B. Table A has the data from Table B. so I want to identify the list of exceptional data which is not present in Table A.

This is table A

Data	Status
AAB	P
AAC	P
AAD	P

This is table B

Data	Status
AA	P
BB	P
AAB	F
BBC	P
AAC	P
AAD	P
AAF	F
AAG	p

Thanks in advance

[atcodedog05 · Accepted solution]

Hi @AS 

You can achieve this with help of join tool. Right unjoin is the data not present in Data A

Hope this helps : )

[AS]

yeah this is so simple. Thanks @atcodedog05 

[atcodedog05]

Happy to help : ) @AS 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!