I have a table like this:
I want to delete lines to get a table like this:
When you have two lines with the same key (first column), just preserve the last one.
Can someone help me on this please?
LOAD F1,F2,-RecNo() as Ord INLINE [
F1 as Final,
Where not Exists(Final,F1)
order by Ord;
drop table T;
Also in Presentation Tab, Select the 'Final' column and check 'Omit Rows Where Field is NULL'.
Retrieving data ...