Compare data of two files to see if info is not populated in one and populated in the othe

[lbolin]

I am trying to compair two data sets to determine if data was populated in that field last month but not this month. 

EX:

July

ID
1001	jill
1002	bob
1003

AUG

ID
1001	jill
1002
1003

I would like to know that nothing was populated in 1002 in Aug bust was populated in July and output the fields that were not populated  in Aug

[JagdeeshN]

Hi @lbolin ,

Please find attached a sample solution to be able to flag the rows with missing data.

Hope this helps.

Best,

Jagdeesh

[KarolinaRoza]

hi @lbolin 

Please see my solution where you can assign comment based on the criteria and then filter for rows which you wish to display.

Karolina