Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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?