Compare Two Data-sets

[BRRLL99]

Hi

I have Two Sheets Name-2000, Name-2022

Expected-Output:

3M	Present in 2000 Also
3i Group	Present in 2000 Also
APA	Present in 2002 Only
Agnico Eagle Mines	Present in 2000 Only

data which is common  i want " Present in 2000 Also"

data removed from data-2000 = "Present in 2000 Only"

data newly added in data-2002 = "Present in 2002 Only"

[Luke_C]

Hi @BRRLL99 

1. Input each sheet using an input tool. 
2. Use a Join tool to join the data on the field you're comparing
3. The L & R outputs of the join tool will be the records added/removed. The J will be common records.
4. Add a formula tool after each output and enter the desired text.

[binuacs]

@BRRLL99 would you be able to provide the sample files?

[BRRLL99]

uploaded, Please Check now

[Robin_McIntosh · Accepted solution]

Here's one way to do it.

[binuacs · Accepted solution]

@BRRLL99 Similar appeoach as @Luke_C mentioned