unique values from coll

Shweta

Active Member
hi,

how to get only unique data from collection like -
col1 col2 col3
ID1 A B
ID2 A P
ID3 B D

So, from above collection, I need only the last row in my output collection where Col2 = B.. All the duplicate records in col B needs to be completely ignored. For example, A is appearing twice in col2 - so this will be removed completely
 
Top