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 ?