Omit the duplicate records

[Guru Salem]

Hi Everyone

 

We have set of records in name field. like Jack, mini, jack, janson, dallas, robin, rack, robin.... totally 20 records.

 

I need a script or find options to disply the unique values, that means i dont want to see the duplicate records like jack,robin

 

I think we have option to omit this duplicate records, Please help you with your intelligence

[eddyb2]

This is done by using a self-join relationship with a counter.

 

It's actually documented pretty well in the Help.

 

In FM Help search for Finding Duplicate values using a self-join relationship

[Guru Salem]

Hi Eddyb2

 

Thanks for the reply, As your comments i cant find any example with the FM Help. its all having only text and texts

 

Could you able to clear the concept that what expecting ?