In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Compare Two Data-sets

BRRLL99
11 - Bolide

Hi

 

I have Two Sheets Name-2000, Name-2022

 

 

Expected-Output:

 

3MPresent in 2000 Also
3i GroupPresent in 2000 Also
APAPresent in 2002 Only
Agnico Eagle MinesPresent 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"

5 REPLIES 5
Luke_C
17 - Castor
17 - Castor

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
21 - Polaris

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

BRRLL99
11 - Bolide

uploaded, Please Check now

Robin_McIntosh
11 - Bolide

Here's one way to do it.

Robin_McIntosh_0-1661346314400.png

 

binuacs
21 - Polaris

@BRRLL99 Similar appeoach as @Luke_C mentioned

 

binuacs_0-1661346498944.png

 

Labels
Top Solution Authors