Skip to Content
0
Former Member
Mar 06, 2015 at 05:43 PM

Comparing two columns

18 Views

Hi All,

I am trying to derive whether a person is manager or not.


I have data in below format:


Managerid EmpId

123 456

123 678

678 101

101 111


I am trying to achieve below format:

Managerid EmpId Is_EMP_Manager

123 456 No

123 678 Yes

678 101 Yes

101 111 No


So each Empid should compare all values in Managerid, If its present then he is manager If not present he is not a manger.

Any Inputs. Thanks