Originally posted by: chinnastar

I have a record consists of number of equipments , i need to pickup unique records of 4 fields in complete file  how to achieve it

when I use extract im getting 4 fields

40,RH,45R1,N
40,RH,45R1,N
20,ST,22G1,N
20,ST,22G1,N
40,HC,45G1,N
40,HC,45G1,N
40,HC,45G1,N
40,HC,45G1,N
20,ST,22G1,N
40,HC,45G1,N
40,HC,45G1,N

my output should be 

40,RH,45R1,N

20,ST,22G1,N

40,HC,45G1,N

20,ST,22G1,N

how to achieve unique function here?

Originally posted by: Bragger

There is a inbuilt function available in WTX - "Unique". You can use "Unique" function along with Extract which will give you unique value. Something like this - UNIQUE (EXTRACT())