Logic Request

[Jaganmohan]

Hi Team,

I am trying to find the odd one from the given data - could you please provide me the logic to find the exceptions?
Given Data :

Prime	Alpha
100	1
100	2
101	1
101	2
102	1
102	2
103	1
104	1
104	2
105	1
106	1
106	2
107	1
107	2
108	1
109	1
109	2

Required Solution :

103	1
105	1
108	1

 Exceptions :  because we don't have alpha 2 in the given data... Could you please try to provide me the logic to get those exceptions - Thanks in advance.

[PhilipMannering]

This is actually very simple. Just use the Filter Tool with the expression,

Prime IN ('103', '105', '108')

Thanks,

P Man

[PhilipMannering]

Sorry @Jaganmohan 

Just understood what you meant. I think the following solution should work for you.