Delete Duplicates in table

[#1]

Hello,

I have a table like this:

A	A-TEST
C	TEST
B	B-TEST
C	C-TEST

I want to delete lines to get a table like this:

A	A-TEST
B	B-TEST
C	C-TEST

When you have two lines with the same key (first column), just preserve the last one.

Can someone help me on this please?

Thanks,

Regards,

Loïc

[Clever_Anjos · Accepted solution]

T:
LOAD F1,F2,-RecNo() as Ord INLINE [
    F1, F2
    A, A-TEST
    C, TEST
    B, B-TEST
    C, C-TEST
];

LOAD
  F1 as Final,
  F2
Resident T
Where not Exists(Final,F1)
order by Ord;


drop table T;

[#3]

Also in Presentation Tab, Select the 'Final' column and check 'Omit Rows Where Field is NULL'.