Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load
distinct( fieldname)
Thanks @Mohan_hitman but I have tried this and it just isn't working for me. Anything else I could try? Thank you
LOAD Distinct will remove
LOAD *
Where Not(Exists(KeyField));
SQL SELECT KeyField,
...
FROM ...;