3 Replies Latest reply on Jul 29, 2016 6:10 AM by Andrew Watson

    Need to display only respective EmpId's in this scenario

    Prasanna P

      Hi All,

       

      Looking for your help in this scenario,

       

      I have a requirement like below,

       

      Consider below table, I need to display only the employee ID's which contains the EventID as 1 and 3 and 5. As per below table, I should display only EmpID 1, Since the EmpId 1 only contain all the three said Event Id's.The EMPID may contain other values also apart from 1,3 and 5. But if these 1,3, and 5 are exist for any EMPId, I need to display that EMPID(s) only. In below example EMPID 1 contain Event ID as 5,3,2,1 and 7 but no issues. Since as per my condition, 1,3 and 5 are existed for only for EMPID 1.So I want to display only EMPID 1.

       

      EmpId  EventId

      1          5

      1          3

      1          2

      1          1

      1          7

      2          5

      2          1

      4          4

      4          3

       

      Please help me to write logic.

       

      PFA for excel and .twbx file

       

      Thanks,