Remove duplicates

[New-here1]

Hi,

I have 2 columns (Risk, Level) and need to remove duplicates from the risk column only. 

How can I do this is the DLscript please? 

Thank you

[Mohan_hitman]

load 

distinct( fieldname)

[New-here1]

Thanks @Mohan_hitman but I have tried this and it just isn't working for me. Anything else I could try? Thank you

[Mohan_hitman]

 LOAD Distinct will remove duplicate identical records, but will not remove duplicate values in one field if they differ in others. To exclude duplicate of a single field, you could use this pattern:

LOAD *
Where Not(Exists(KeyField));
SQL SELECT KeyField,
...
FROM ...;