Merge Tables and add only rows that don't match first query

[Anonymous]

Hi there,

I have two tables A and B. A contains names and ID's of current and former employees. Table B contains only current employees. 

How can I merge these so that I get all information from Table B and names and ID's that don't match values in Table B from Table A?

TableA			TableB
ID	Name		ID	Name	Location	Title
1	Max		1	Max	Pit	Manager
2	Dave		2	Dave	NY	Analyst
3	Tina		5	Carl	NY	Consultant
4	Cindy		6	Mike	NY	Analyst
TableC
ID	Name	Location	Title	Current employee
1	Max	Pit	Manager	yes
2	Dave	NY	Analyst	yes
3	Tina			no
4	Cindy			no
5	Carl	NY	Consultant	yes
6	Mike	NY	Analyst	yes

I tried appending the tables but every time I try to remove the duplicates I remove the rows that have non blank values in Location and Title.

[mahoneypat · Accepted solution]

Add a filter step to TableA to keep only the rows not in Table B. Shown below. Then append TableA to TableB to get your result.

Pat