Matching within 2 data sets

[SUNIL8634]

Hi All,

Can anyone help me in comparing 2 data sets to figure/report what has changed (as it involves 2 different period).

The below is an example:

Data set 1:

User	System 1	System 2	Period
Alex		Yes	2020
Rebecca	Yes		2020
Clair	Yes		2020

Data set 2:

User	System 1	System 2	Period
Alex	No		2019
Rebecca		Yes	2019
Clair	Yes		2019

The solution should say as below:

User	System 1	System 2
Alex	Removed	New User
Rebecca	New user	Removed
Clair	No Change	No Change

Thanks in advance.

[AbhilashR · Accepted solution]

Hi @SUNIL8634, could you give the approach illustrated in the attached solution a try and let us know if it addresses your ask?

[grazitti_sapna · Accepted solution]

Hi @SUNIL8634 , I hope this what you are looking for?

Thanks.

[SUNIL8634]

Thanks Abhilash. I was able to leverage your suggestion!