Start Free Trial

Alteryx Designer Desktop Discussions

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

Compare Two Datasets to find any variance

alkafalhas
7 - Meteor

Below is the example of two datasets. I'm trying to check if these two datasets are match to each other. I would like to have an output like shown below. Please feel free to share if there is any better way to do this. Any help is appreciated!

Thank you!

 

Dataset A

 

ABC
147
258
369

 

Dataset B

ABC
147
258
369

 

Desire Output

 

ABC
TRUETRUETRUE
TRUETRUETRUE
TRUETRUETRUE
2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@alkafalhas 
Something like below should do the work.
I also forged some data to test it.

1221-alkafalhas.PNG

Tyro_abc
11 - Bolide

Hi @alkafalhas 

Check the attached workflow!

 

arundhuti726_0-1608528602646.png

 

Labels
Top Solution Authors