delete duplicates by a key

[Anonymous]

Hi,

I have a table of 5 fields, but I my key is 3 fields, I don't want to have duplicates by this 3 fields.

I want to sort by this 3 fields and eliminate duplicates

How can I do it?

Thanks

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this:

LOAD

     Field1,

     Field2,

     Field3,

     Field4,

     Field5,

     Autonumber(Field1, Field2, Field3) as Key

FROM

     ...source_data...

WHERE

     NOT EXISTS (Key, Autonumber(Field1, Field2, Field3) )

     ;

DROP FIELD Key;

[jlongoria]

I can think of a couple of things you may want to do but I'm not sure. Can you post sample data and sample desired results?