Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Show employees with more than one ID

Hi,

I only want to see the rows with employees with more than one records and each record.

 

ID, Employees

1,A

2,A

3,B

4,C

5,C

6,F

 

So my outcome I want is.

 

ID,Employees 

1,A

2,A

4,C

5,C

In expression or code.

Thanks

 

 

Labels (1)
10 Replies
D19PAL
Creator II
Creator II
Author

Thanks everyone.

I think everyone's worked, but I used the one in the script added a distinct and a where clause and its working