Find Newly Added Names

[BRRLL99]

Hi,

i have two tables with with 2000 rows each

TABLE-1

NAME	COUNTRY
APPLE	USA
AMAZON	USA
SAMSUNG	SOUTH KOREA
BANK OF CHINA	CHINA

TABLE-2

NAME	COUNTRY
APPLE	USA
AMAZON	USA
SAMSUNG	SOUTH KOREA
Nutrien	Canada
KIA	South Korea

EXPECTED OUT-PUT:

NAME	COUNTRY	STATUS
Nutrien	Canada	Newly Added
KIA	South Korea	Newly Added
APPLE	USA	Present Previously
AMAZON	USA	Present Previously
SAMSUNG	SOUTH KOREA	Excluded

[DavidSkaife · Accepted solution]

Hi @BRRLL99 

One way of doing this:

[IraWatt]

Hey @BRRLL99,

You will have to explain the rules here. Why is does SAMSUNG South Korea have status Excluded but APPLE USA is status Newly Added?

[DataNath]

Here's how I'd approach it. Though from your example, I'm not sure why Samsung has been marked 'Excluded', and you no longer have the Bank of China? Is there any logic behind this or just not a comprehensive list in your desired output?