Hi, i have two tables with with 2000 rows each TABLE-1 NAMECOUNTRYAPPLEUSAAMAZONUSASAMSUNGSOUTH KOREABANK OF CHINACHINA TABLE-2 NAMECOUNTRYAPPLEUSAAMAZONUSASAMSUNGSOUTH KOREANutrienCanadaKIASouth Korea EXPECTED OUT-PUT: NAMECOUNTRYSTATUSNutrienCanadaNewly AddedKIASouth KoreaNewly AddedAPPLEUSAPresent PreviouslyAMAZONUSAPresent PreviouslySAMSUNGSOUTH KOREAExcluded

Find Newly Added Names

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

Data Investigation

Accepted answers

davidskaife

Hi @BRRLL99

One way of doing this:

New Workflow1.yxmd

All comments

davidskaife

Hi @BRRLL99

One way of doing this:

New Workflow1.yxmd

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?

Check for new names.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703