Finding the subset of a table with only distinct entries

[nougatitati]

Hi,

This is potentially a very basic question, but I have not been able to resolve it on my own.

I have a table with 18 fields, 3 of which are timestamps which sometimes have duplicate entries all simultaneously for many records (due to a data entry error). I want to create a version of this original table with no duplicate entries for these three fields. I have tried

NoConcatenate UniqueTimestampsTable:
LOAD Distinct UnitName, [timestamp1], [timestamp2], [timestamp3]
Resident TableWithDuplicateTimestamps;

However this means I don't have any of the other attribute information for each of the records. To do my analysis, I need a table with all 18 fields included for each record. To do this, I tried a left join with:

Left Join (UniqueTimestampsTable)
AnotherOne:
Load
    [ID],
    [field0],
    [field1],
    [field2],
    [timestamp1],
    [field3],
    [field4],
Resident TableWithDuplicateTimestamps;

Where I intended the tables to join via timestamp1, and have only the entries of the former table included in the joined table (hence the left join). However, this does not work as intended, and I have numerous duplicate entries for all three timestamp entries.

I think I am overengineering my solution to this. How can I resolve this?

[nougatitati]

Great thanks so much! I appreciate the time you put into this.

---

That is quite basic and I hope this is clear

---

Saying this is a really good way to make people afraid to ask questions, Lech!

[Lech_Miszkiewicz]

I see how you interpreted it....

Apologies - i meant that my explanation is quite basic and that I hope it is clear..