Loading just the max record in each group

[richard_chilvers]

Hi

This seems a simple issue, but I cannot find the solution on here !

My table has the following fields per record:

Index, date, field1, field2

For each value of Index, I want to load just the record with MAX(date).

I believe   LOAD Index, MAX(date) from table group by Index    would work.

But how do I include field1 and field2 ?

Thanks.

[Gysbert_Wassenaar]

Left join it with the load of all fields:

load Index, max(date) as date from table group by Index;

left join load Index, date, field1, field2 from table;